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

Adding Criteria

The criteria that you set for your query determines how the field information found in the selected fields appears in the completed query. You set criteria in the query to filter the field data. The criteria that you set in a query are similar to the criteria that you worked with when you used the filtering features in Lesson 16, "Sorting, Filtering, and Indexing Data."

For example, suppose you have a query where you have selected fields from an Employee table and a Department table (which are related tables in your company database). The query lists the employees and their departments. You would also like to list only employees that were hired before March 1999. This means that you would set a criteria for your Start Date field of <03/01/99. Using the less-than sign (<) simply tells Access that you want the query to filter out employee records where the start date is before (less than) March 1, 1999.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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