Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Nonmatching records in different tables

    Hi all, I have two tables (table A and table B), containing records that reference each other using a "KEY" field... there is a one to many relationship from table A to table B... there is supposed to be at least one corresponding record in table B for each record in table A, I have discovered that this is not true due to record entry errors... My question is that "is there an easy way to run a query that will show only records from table A where there is NO corresponding record in table B ?"Thank you
    Kevin

  2. #2
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    147
    Thanked 156 Times in 149 Posts
    In Access 2003 there's a wizard on the query tab called 'Find unmatched Query Wizard'. I assume there's something like it in newer versions of Access. Just follow the directions....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •