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

Adding Criteria

Criteria is familiar to you if you read Lesson 19, which deals with filters. Criteria enable you to choose which records appear in your query results. For example, I could limit my list of dogs to those whose birth dates were before 1/1/94.

Tip

Filters versus Queries If the primary reason for creating the query is to filter, you might want to create the filter part first by using one of the procedures described in Lesson 19, and then save the filter as a query. You can open that query in Query Design view and fine-tune it as needed.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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