I am suppose to create a query to find all records in my “Student” (school work) table in which the Nation field value starts with either “A” or “I”. I have entered this in the Nation column criteria: In (“A”) or (“I”), and it results in an empty query result. I have many different senarios in which the same results have occured or syntax errors. I am at a loss and need help to figure it out. I am suppose to end up with so many Austria and Australia results and so many Ireland and Italy results. Just can’t get it figured out.
Thanks in advance,
Mike Ortega
