Microsoft Office Tutorials and References
In Depth Information
To Use a Criterion in a Query
After you have determined the ﬁ elds to be included in a query, you will determine whether there are any
restrictions on the records that are to be included. For example, you might only want to include those clients
whose recruiter number is 24. In such a case, you need to enter the 24 as a criterion , which is a condition that
the records to be included must satisfy. To do so, you will open the query in Design view, enter the criterion below
the appropriate ﬁ eld, and then view the results of the query. The following steps enter a criterion to include only the
clients of recruiter 24 and then view the query results.
• Right-click Client Query to produce
a shortcut menu (Figure 2–6).
clicking Open opens
the query in Datasheet
view and displays the
clicking Design View
opens the query
in Design view
so you can make
• Click Design View on the shortcut
menu to open the query in Design
view (Figure 2–7).
ﬁ eld list
Number ﬁ eld