hi all


looking for a query that would achieve the following


i have 2 tbls

tb1 tb2

each one has a single feild called "colour"

what i want is a query that when the 2 tbls are joined in query and any feilds values are equal do not show these values


ie if red was in tb1 and in tb2 then only show unmatched records
so if tb1 had yellow but not in tb2 then show these results


many thanks in advance


Regards Joe

Hi Joe,



Have you tried using the "Find Unmatched Query Wizard?"

Just my 2 cents...

If in design view put this in your tbl1.colour fields criteria:

Not tbl2.colour