Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    1

    Cool Unanswered: Find Unmatched records between two tables

    Hi, I'm trying to get the unmatch records from two fields from two different tables, in Access 2000.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by cartayr
    Hi, I'm trying to get the unmatch records from two fields from two different tables, in Access 2000.
    Run the Unmatched query wizard.
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Agree with MO.

    Run the query wizard BUT if like myself you need to make a small adjustment open the query in SQL and make a second part to the original search by adding AND and the routine -- if you need more help there SHOUT

    regards

    gareth

Posting Permissions

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