Finding unmatched records in Microsoft Access

If you want to find records with no corresponding records in related tables, you can also use the Find Unmatched Query Wizard. This yields the same result as using Is Null in the QBE grid criteria. Please note however that using the query wizard may slow down a computer network.

To find Unmatched Queries if using Microsoft Access 2003 or earlier:

In the Database window, click the Queries object button, and then click New.

In the New Query dialog box, click Find Unmatched Query Wizard, then click OK. The first Find Unmatched Query Wizard dialog box will be displayed.

Select the table or query that contains records that you want in the query results, and then click Next.

Select the table or query containing the related records, then click Next.

Select the field that is common to both tables, and then click the button. Click Next.

Select the fields from the Available fields list that you want including in the query results, clicking the  button between each addition, or click  to include all fields in the query results. Click Next.

Give a suitable name to your query, and then click Finish.

The results of the query will be displayed.

To find Unmatched Queries if using Microsoft Access 2007 or Microsoft Access 2010:

Click the Create tab, and then in the Other group, click Query Wizard. The New Query dialog box will be displayed.

In the New Query dialog box, click Find Unmatched Query Wizard, then click OK. The first Find Unmatched Query Wizard dialog box will be displayed.

Select the table or query that contains records that you want in the query results, and then click Next.

Select the table or query containing the related records, then click Next.

Select the field that is common to both tables, and then click the button. Click Next.

Select the fields from the Available fields list that you want including in the query results, clicking the button between each addition, or click to include all fields in the query results. Click Next.

Give a suitable name to your query, and then click Finish. The results of the query will be displayed.

To find out more about our Microsoft Access training courses Sydney, Australia, please visit http://www.jmdtraining.com.au/microsoft-office-training/microsoft-access-training.

To find out more about our Microsoft Access training courses London, UK, please visit http://www.jmdtraining.co.uk/microsoft-office-training/microsoft-access-training

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Uncategorized and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s