Results 1 to 2 of 2
  1. 09-25-2013, 09:47 AM #1
    jre1229
    jre1229 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    30

    Reverse Link? Need to show where there is no match


    I have a query looking at two tables. What I would to show is which records in "table1" do NOT have a match in "table2" Any suggestions. All I am getting now is the ones that do have a match.
    Reply With Quote Reply With Quote
  2. 09-25-2013, 10:43 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Try the unmatched query wizard.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Reverse relationships
    By PapaBear in forum Access
    Replies: 11
    Last Post: 01-22-2013, 12:59 PM
  2. choose which records link to a new addition (reverse of already defined)
    By DatabaseIntern in forum Forms
    Replies: 8
    Last Post: 06-08-2012, 02:27 PM
  3. Reverse Sequence of Numbers
    By OpsO in forum Queries
    Replies: 1
    Last Post: 08-12-2010, 06:05 PM
  4. Reverse Cross Tab
    By indiana in forum Access
    Replies: 1
    Last Post: 03-12-2010, 10:11 PM
  5. Reverse an .mde
    By Marion in forum Access
    Replies: 2
    Last Post: 12-07-2009, 03:09 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums