Microsoft Office Tutorials and References
In Depth Information
Finding Unmatched Records with a Wizard
7. Click the View button to view the datasheet again.
Check to make sure that you see only the records that the delete query
should delete. If you see data in the datasheet that shouldn’t be deleted —
or if data that you want to delete is missing — correct the design of the
query before you run it.
A delete query deletes entire records.
8. Return to Design view by clicking the View button.
9. Click the Run button to run the query.
Access deletes the data that you saw in Datasheet view. It’s gone
for good!
Finding Unmatched Records with a Wizard
Access has two categories of Neat Things You Can Do with Queries: action
queries and the two query wizards covered in this section. The Find
Unmatched Query Wizard finds records in one table that have no matching
records in another, related table. You may store orders in one table and
details about customers in another table, for example. If the tables are linked
by, say, a Customer Number field, the Unmatched Query Wizard can tell
you whether you have any customers listed in the Orders table who aren’t
listed in the Customers table.
Use the Find Unmatched Query Wizard to find unmatched records in the
following way:
1. Click the Query Wizard button in the Queries group on the Create tab
of the Ribbon.
The New Query dialog box opens.
2. Select the Find Unmatched Query Wizard option and then click OK.
The first window of the wizard appears.
3. Select the table (or query) that may have unmatched records in a
second table and then click Next.
If you’re looking for customers with no orders, select the table that
holds the names of customers in this window. If you’re looking for
orders for which you don’t have the customer address, select the
Orders table in this step. The final result of the query lists records from
the table that you select in this step that don’t have matching records in
the table you select in the next step.
If you want to choose a query, select the Queries or Both radio button.
Search JabSto ::




Custom Search