Matching problem...

[derr04]

We have two databases that I am tryin to match it one variable, we get it to to match and take from the first database and enter it in the second but I was wondering how I can get a report on the ones that didnt match. Im sorry if this is a simplistic problem but I am kind of new to Access and didnt know where else to turn to help.

 

[RuralGuy]

Have you tried to use the Unmatched Query Wizard?

 

[The_Doc_Man]

RG is correctly, but to expound the explicit - don't forget that to query two tables in two different databases, you must establish a link in the database where you are working to the other database. Otherwise the unmatched query wizard will not know where to look..