Query to return values that are not equal

[kdt]

I have a query that uses a linked table from an external database and joins it with a table from my database to return records that contain the same values.

Is there a way to return only the records that are present in the external database and not in my db?

Thanks

 

[neileg]

Use the unmatched query wizard.

 

[kdt]

I am such a numpty, I think I'll just go and flush myself down the toilet.

Thanks for the quick reply

 

[neileg]

We're all numpties sometime! Don't bother with the toilet.