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

Chapter 5. Working with Queries > Specifying Query Criteria

Specifying Query Criteria

You're almost done: you've chosen the tables you want and selected the fields that contain the data you want to get at. All you need to do now is tell Access which records to pull from your tables. You do this by using criteria.

If you're working with numerical values, sim ply type in the value you want to use as the base. For instance, if you're working with a table that contains bibliographic information, you can type =1996 in the criteria of the Copy rightYear field to find all of the books published in 1996. You can use other operators, such as > (greater than), < (less than), and <>(not equal to) in your criteria (use the greater-than and less-than keys on the keyboard).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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