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