Microsoft Office Tutorials and References
In Depth Information
To Restrict the Records in a Join
Sometimes you will want to join tables, but you will not want to include all possible records. For example,
you would like to create a report showing only those clients whose Amount Paid is greater than $20,000, but you do
not want the Amount Paid fi eld to appear in the results. In such cases, you will relate the tables and include fi elds
just as you did before. You also will include criteria. To include only those clients whose amount paid is more than
$20,000.00, you will include >20000 as a criterion for the Amount Paid fi eld.
The following steps modify the Recruiter-Client query to restrict the records that will be included in the join.
1
Open the Recruiter-Client Query
in Design view and hide the
Navigation pane.
Add the Amount Paid fi eld to
the query.
Amount Paid
fi eld added
Type >20000 as the criterion for
the Amount Paid fi eld and then
click the Show check box for
the Amount Paid fi eld to remove
the check mark (Figure 2–58).
check mark
removed
criterion for
Amount Paid
fi eld
amount paid
must be greater
than $20,000
Figure 2–58
2
View the query results
(Figure 2–59).
3
Close the query by clicking
the Close ‘Recruiter-Client
Query’ button.
When asked if you want to save
your changes, click the No button.
clients whose
amount paid
is greater than
$20,000
Figure 2–59
 
Search JabSto ::




Custom Search