Access Query

[Jimmy2128]

I have 2 tables A and B. I want to exclude all the names from B that are currently on A. What would be the best way to create this....

Thanks

Jimmy

 

[DoubleD]

Write a query using outer join from B to A.
Your criteria should be where a field from A Is Null.

I am what I am based on the decisions I have made.

DoubleD

 

[GingerR]

You can even use the Find Unmatched query wizard then see how Access writes the query to learn how to do it.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244