Microsoft Office Tutorials and References
In Depth Information
To Add Fields to the Design Grid
Once you have a new query displayed in Design view, you are ready to create the query by making entries in the
design grid in the lower pane of the window. You add the ﬁ elds you want included in the Field row in the grid. Only
the ﬁ elds that appear in the design grid will be included in the results of the query. The following step includes the
client number, client name, amount paid, and current due for all clients by adding only those ﬁ elds in the design grid.
• Double-click the Client Number
ﬁ eld in the ﬁ eld list to add the
Client Number ﬁ eld to the query.
What if I add the wrong ﬁ eld?
Click just above the ﬁ eld name
in the design grid to select the
column and then press the DELETE
key to remove the ﬁ eld.
Number ﬁ eld
• Double-click the Client Name ﬁ eld
in the ﬁ eld list to add the Client
Name ﬁ eld to the query.
Name ﬁ eld
Paid ﬁ eld
• Add the Amount Paid ﬁ eld to
the query by double-clicking the
Amount Paid ﬁ eld in the ﬁ eld list.
Due ﬁ eld
• Add the Current Due ﬁ eld to the
query (Figure 2–12).
What if I want to include all
ﬁ elds? Do I have to add each ﬁ eld
No. Instead of adding individual
ﬁ elds, you can double-click the
asterisk (*) to add the asterisk to
the design grid.
Client Number, Client
Name, Amount Paid,
and Current Due
ﬁ elds added to query
Number ﬁ eld
When you use queries, usually you are looking for those records that satisfy some
criterion. In the simple query you created earlier, for example, you entered a criterion to
restrict the records that were included to those on which the recruiter number was 24. In
another query, you might want the name, amount paid, and current due amounts of the
client whose number is FD89, for example, or of those clients whose names start with the
letters, Be. You enter criteria in the Criteria row in the design grid below the ﬁ eld name