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

Lesson 20. Modifying a Query > Adding Criteria

Adding Criteria

Criteria will be familiar to you if you read Lesson 18, which deals with filters. Criteria enables you to choose which records will appear in your query results. For example, I could limit my list of dogs to those whose birth dates were before 8/5/94.

Filters versus Queries

If the primary reason for creating the query is to filter, you may want to create the filter part first using one of the procedures described in Lesson 18, and then you can 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