Results 1 to 2 of 2
  1. #1
    Hyunjee is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    Posts
    5

    Need to find unmatched records and have query results of the unmatched records only

    I have two tables of the same data. We are doing dual data entry to help the data be more accurate. In access the same data are entered into two different forms. I am wanting to compare all the variables in each data set to each other and output them into my query results. I know I can do a find unmatched query results through the query wizard, but it just takes the records that do not match in table 2 to table 1 out of the results. I want the records for which any of the variables do not match from table 2 to table 1 output into a table. I would like to have all the variables in table 1 and all the variables in table 2 listed. The problem is, when I use the unmatched query wizard, I am able to tell which IDs from both tables have differing data, but I cannot compare the variables entered into both tables into one another so I can see which variables were entered incorrectly. I am not sure if this is possible to do.


    Also, I was used to using Access 2003 and am now having to use 2010.
    Thank you for any help you can provide.

    HyunJee

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The UnMatched Query wizard *returns* the records that do not match. You can modify the query so it does just as you want.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unmatched query with multiple criteria
    By brighteyes in forum Access
    Replies: 0
    Last Post: 10-26-2011, 06:37 AM
  2. Unmatched query on 1 table
    By tmcrouse in forum Access
    Replies: 7
    Last Post: 06-01-2011, 08:38 AM
  3. Unmatched with multiple columns and rows
    By sampson20 in forum Programming
    Replies: 1
    Last Post: 04-18-2011, 10:48 AM
  4. Unmatched query to lookup part of the field
    By DMetcalfe in forum Queries
    Replies: 15
    Last Post: 10-08-2010, 05:30 AM
  5. UnMatched Data Query (Edit Data)
    By pedraza4 in forum Queries
    Replies: 3
    Last Post: 06-16-2010, 07:29 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums