Access Query To Compare Two Tables. Meaning to compare Table B - fields against Table A - fields to produce no match report. If you only have two lists to compare you can create two mismatch outer join queries and combine them with a Union query.
Use the Find Unmatched Query Wizard to compare two tables. Create a query in Query Design. Active 7 years 5 months ago.
I always find its a good idea to use Excel Tables with your data.
In the Table Name box type the name of the sample table and then click OK. The reason that I. Compare Two Tables using Co-related Subquery. Compare two tables in one database or identically named tables in two databases MDB ADP or ACCDB formats.
