Microsoft Office Tutorials and References
In Depth Information
Reference Window | Using the Find Unmatched Query Wizard
• In the Other group on the Create tab, click the Query Wizard button.
• Click Find Unmatched Query Wizard, and then click the OK button.
• Complete the Wizard dialog boxes to select the table or query on which to base the new
query, select the table or query that contains the related records, specify the common
field in each table or query, select the additional fields to include in the query results,
enter a name for the query, and then click the Finish button.
Oren wants to know which customers have no open contracts. These customers are
inactive, and he will contact them to determine their interest in doing further business
with Belmont Landscapes. To create a list of inactive customers, you’ll use the Find
Unmatched Query Wizard to display only those records from the tblCustomer table with
no matching CustomerID field value in the tblContract table.
To create the query using the Find Unmatched Query Wizard:
1. In the Other group on the Create tab, click the Query Wizard button to open the
New Query dialog box.
2. Click Find Unmatched Query Wizard , and then click the OK button. The first Find
Unmatched Query Wizard dialog box opens. In this dialog box, you select the table or
query on which to base the new query. You’ll use the qryCustomersByName query.
3. Click the Queries option button in the View section to display the list of queries,
click Query: qryCustomersByName in the list box to select this query, and then
click the Next button to open the next Find Unmatched Query Wizard dialog box,
in which you choose the table that contains the related records. You’ll select the
4. Click Table: tblContract in the list box (if necessary), and then click the Next but-
ton to open the next dialog box, in which you choose the common field for both
tables. See Figure 5-27.
Selecting the common field
If the two objects you
selected for the find
unmatched query have a
defined in the Relationships
window, the Matching fields
box will join the two correct
click to confirm
primary key in the
foreign key in the
will appear here
The common field between the query and the table is the CustomerID field. You
need to click the common field in each list box, and then click the symbol between
the two list boxes to join the two objects. The Matching fields box then will display
CustomerID <=> CustomerID to indicate the joining of the two matching fields.