G Guest May 11, 2005 #1 I want to compare two tables and list out the rows that are in one table and not in the other. Does anyone know how to do this?
I want to compare two tables and list out the rows that are in one table and not in the other. Does anyone know how to do this?
M Marshall Barton May 12, 2005 #2 mce said: I want to compare two tables and list out the rows that are in one table and not in the other. Does anyone know how to do this? Click to expand... The query wizard knows how ;-) Seriously, just create a new query and select the wizard for Find Unmatched Query.
mce said: I want to compare two tables and list out the rows that are in one table and not in the other. Does anyone know how to do this? Click to expand... The query wizard knows how ;-) Seriously, just create a new query and select the wizard for Find Unmatched Query.