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

Chapter 6. Locating Specific Information... > Specifying Criteria for Multiple Fie...

Specifying Criteria for Multiple Fields

You can specify several query fields. If the criteria for the fields occupy the same row in the Query Design window, Access retrieves records for which all of the criteria are satisfied. For example, if you specify the vendor ID as “LT” (TnT Lighting) and the product price equal to “9.99,” only products equal to $9.99 by LT will be retrieved. On the other hand, if the criteria are entered into different rows, Access retrieves records for which any of the criteria are satisfied. For example, placing “LT” and “9.99” in different rows will cause Access to retrieve either LT products or products with the price $9.99.

Specify Criteria for Multiple Fields in a Query

Display the query in Design view.

Enter the criteria value or values for the first field.

Enter a criteria value or values for additional fields.

Click the Run button on the Query Design toolbar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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