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).
Figure 6.20. You can supply more than one Criteria field. They will act as though they were connected by Ands.
Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
