G'day,

Since MS Access does not support MINUS or EXCEPT, how do I get the results of one query excluding the results from another query?

I am using 2 separate tables with the same fields and 3 keys each.


Cheers,
d-fxt

Use the Find Unmatched query wizard, and then dissect the SQL if you need to make any changes.

IOW, Create the two queries, then create a Find UnMatched query between the two.

Did that work? It basically works like a subquery.



mmcdonal

You beaut.

Thanks mmcdonal.