Microsoft Office Tutorials and References
In Depth Information
to which the criterion applies. For example, to indicate that the client number must be
FD89, you ﬁ rst must add the Client Number ﬁ eld to the design grid. You then would type
FD89 in the Criteria row below the Client Number ﬁ eld.
To Use Text Data in a Criterion
To use text data (data in a ﬁ eld whose data type is Text) in criteria, simply type the text in the Criteria row
below the corresponding ﬁ eld name. The following steps query the Client table and display the client number, client
name, amount paid, and current due amount of client FD89.
• Click the Criteria row for the
Client Number ﬁ eld to produce an
• Type FD89 as the criterion
shape is I-beam
• Click the View
button to display
the query results (Figure 2–14).
I noticed that there is a View
button on both the Home tab and
the Design tab. Do they both have
the same effect?
Yes. Use whichever one you ﬁ nd
only client FD89