Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 17th, 2012, 02:06 PM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default Related tables

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?
Reply With Quote
  #2 (permalink)  
Old March 18th, 2012, 07:55 AM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Use the "Find Unmatched Query Wizard" wizard in Access

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,
__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->
Reply With Quote
The Following User Says Thank You to gjgriffith For This Useful Post:
Dale (March 19th, 2012)
  #3 (permalink)  
Old March 19th, 2012, 07:01 AM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default

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.
Reply With Quote
  #4 (permalink)  
Old March 19th, 2012, 05:23 PM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Great!

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,
__________________
Geoffrey L. Griffith
http://www.ImagineThought.com

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting related tables to excel crisan Access 10 July 24th, 2012 04:23 PM
single submit to related tables forumuser BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 10 December 2nd, 2007 10:29 AM
Synchronising Two Sets of Related Tables Odeh Naber Access 11 May 14th, 2007 06:58 AM
Insert record Into 2 related tables at once kalchev ASP.NET 2.0 Basics 2 May 9th, 2006 05:10 AM
Insert on 2 Related tables question acdsky Classic ASP Databases 1 July 21st, 2004 09:29 PM



All times are GMT -4. The time now is 09:53 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.