Simple one re eliminating info

[paulmcdonnell]

Hi guys

long time no speak ... been on a different project for a while....

hope all is well in Access world .. (No wars anyway)
MY PROBLEM...

I have data source 1 with 1000 records

I have data source 2 with 400 records

i need to produce a query which identifies the 600 remaining records only

I might be being a bit thick but how do i build a query using the two tables that will acheive this....

Hope you can help

Paul

 

[Mile-O]

Are you saying that the same records are kept in both tables?

If so, make a Find Unmatched Query with the query wizard.

 

[paulmcdonnell]

THicky

Oh my god yes!

Mental block just embarassed me..... (spelling often does to ...)


Thanks for that


Paul