Related tables

Dale · March 17th, 2012, 02:06 PM

I have two tables with a one to many relationship. How can I create a query tell me what records may be in one table (the many side) that does not have related data in the other?

gjgriffith · March 18th, 2012, 07:55 AM

Hello Dale,

Thank you for posting your question about Access queries here! Specifically, you asked:

Quote:

How can I create a query tell me what records may be in one table (the many side) that does not have related data in the other?

The cool thing about Access is that it makes building this kind of query really easy using the Query Wizard. I'm not sure what version of Access you are using, but in Access 2010, you can:

1. Open your database in Access 2010 and go to the "Create" Ribbon.
2. On the "Create" Ribbon, click on the "Query Wizard" button. This will start the Query Wizard.
3. On the first page of the Query Wizard, choose the "Find Unmatched Query Wizard" option (which is the 4th option), and click OK.
4. This will launch the "Find Unmatched Query Wizard". Follow the on screen steps in the wizard to build the query (for your specific database tables) and the query will be created!

Anyway, I hope that helps, but if you have any more questions, please feel free to respond and I will do my best to help!

Sincerely,

Dale · March 19th, 2012, 07:01 AM

I guess I forgot to mention I have 2007 at home and 2010 at work. This question was for different projects at both. Thanks for the assist.

gjgriffith · March 19th, 2012, 05:23 PM

Hello Dale,

Thank you so much for the follow up to this post! No worries about not posting the version of Access that you are using, it is VERY EASY not to consider. But Access does vary quite a bit when you start going back a few versions, so I just wanted to make sure I told you the answer for the version you're using. And in your case, these steps should be basically identical for both Access 2007 and Access 2010, so hopefully you are in really good shape and have got this all worked out by now! But if there is anything else I can do to help, please post and I'll do my best to provide an answer.

Thanks again,