• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 6. Creating Queries > Entering Multiple Criteria with the OR Operator

Entering Multiple Criteria with the OR Operator

After you've displayed the query for which you want to enter criteria in Design view, click the cell in the Criteria row for the field you want to match, and type your first criterion (here, IN).

Click in the or row in the same column, and type the second value you want to match (in this case, KY).

Click the Save button on the Standard toolbar in the main Access window to save the query design.

Click the Run button to run the query.

INTRODUCTION

There may be times when you want to match more than one criteria. For instance, you might want to list all clients who live in Indiana, as well as those clients who live in Kentucky, as outlined here. To do so, you use the OR operator.


TIP

Quotation Marks

Access will automatically add quotation marks around your entry. You'll see these if you move to another field or open the query.


Access runs the query and displays a table containing only those records that match the criteria you entered (in this case, clients in Indiana or Kentucky).

Click the Close button to close the query window.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint