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 ﬁ eld to appear in the results. In such cases, you will relate the tables and include ﬁ 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 ﬁ eld.
The following steps modify the Recruiter-Client query to restrict the records that will be included in the join.
• Open the Recruiter-Client Query
in Design view and hide the
• Add the Amount Paid ﬁ eld to
ﬁ eld added
• Type >20000 as the criterion for
the Amount Paid ﬁ eld and then
click the Show check box for
the Amount Paid ﬁ eld to remove
the check mark (Figure 2–58).
must be greater
• View the query results
• Close the query by clicking
the Close ‘Recruiter-Client
• When asked if you want to save
your changes, click the No button.
is greater than