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

Chapter 6. Importing Data: Further Consi... > Using Criteria with Microsoft Query

Using Criteria with Microsoft Query

The previous section showed how you can use criteria in Microsoft Query to resolve problems caused by null values in pivot tables. Microsoft Query provides more flexible criteria, termed parameters, in much the same way as does Microsoft Access.

When you tell Microsoft Query, or a database manager such as Microsoft Access or SQL Server, that you want it to return only certain records, you do so by means of a criterion. Perhaps you want to see only those birth records where the birth weight exceeds 2,000 grams. Then you would supply that weight as a criterion (see Figure 6.20).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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