Meenakshi has created queries in the Query Design view only with a single criterion. She wants to specify criteria to display all the students with grade ‘A’ or ‘E’ from her results table. Help her with the steps that she can take to specify multiple criteria.
Answers
Answered by
2
To see information when either two or more alternate criteria are satisfied, use the or criteria rows in the Access query design grid.
If you’d like a refresher, see applying criteria to a query.
For example, if a business has customers in several different countries and they are running a promotion only for customers in France, UK and USA. To get a list of customers from just these countries, here’s how you can use the OR row:
Similar questions