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 fi elds you want included in the Field row in the grid. Only
the fi 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 fi elds in the design grid.
1
Double-click the Client Number
fi eld in the fi eld list to add the
Client Number fi eld to the query.
What if I add the wrong fi eld?
Click just above the fi eld name
in the design grid to select the
column and then press the DELETE
key to remove the fi eld.
Client
Number fi eld
Double-click the Client Name fi eld
in the fi eld list to add the Client
Name fi eld to the query.
Client
Name fi eld
Amount
Paid fi eld
Add the Amount Paid fi eld to
the query by double-clicking the
Amount Paid fi eld in the fi eld list.
Current
Due fi eld
Add the Current Due fi eld to the
query (Figure 2–12).
What if I want to include all
fi elds? Do I have to add each fi eld
individually?
No. Instead of adding individual
fi elds, you can double-click the
asterisk (*) to add the asterisk to
the design grid.
Client Number, Client
Name, Amount Paid,
and Current Due
fi elds added to query
criteria row
for Client
Number fi eld
Figure 2–12
Entering Criteria
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 fi eld name
 
Search JabSto ::




Custom Search