Showing all details that are in one table, but not the other.

[AccessDenied]

Hi Guys,

Don't use access very often to be honest, only time to time to keep people in line. This one's beyond my very limited knowledge though, so i thought someone could help.



I've two tables, full of records, about 10 columns each. I can link these tables with reference id's so i can show all the items that occur in both tables, but what i'm wanting to show is all the items that occur in table 1 but doesnt occur in table 2.


Heelllp!

[pbaldy]

See if the Unmatched query wizard gets you what you want.