Compare two tables and show it in a form

[Jim.H.]

Compare two tables and show it in a form


I have these tables:
Table1:
ID, Date, Code
Table2:
ID, Date, Code
Now I need to compare these two tables based on ID and Date and show matching records, the ones extra in Table1 and the ones Extra in Table2. How can I do this?

[aytee111]

Depends what you want to do with the information.

Three listboxes? First one showing matches - query which joins tables on Date and Code. Second one showing ID's in table 1 which don't appear in query 1. Third one showing ID's in table 2 which don't appear in query 1. (Use non-matching query wizard).