Comparing Tables - Internal / External

[DianaW]

Dear Forum,

please let me ask a second question. I have two tables tbX and tbY, which both contain a column called "LastName". What I am looking for is a query or macro, which compares the columns "LastName" of tbX and tbY and then tells me, which items are contained in tbX but not in tbY.

To make it more complicated I have two cases. In the first case both tables are located in the same database. However, in the second case one of the two tables is not part of my database but located in a different Access-file in a different directory.

I would be happy for any suggestions.

Thank you.
Diana

 

[David Eagar]

Link the table from the external database is the first step and then I think an unmatched query (I have never tried one of these yet, so no idea of technique, hopefully the wizard should guide you through)

 

[Simon_MT]

My first question is why have two tables?

The second how do you correlate records between the two tables?

Simon

 

[DianaW]

Thank you.

Both tables have the same columns, however one is the output of another programme, thus I cannot change it.

However, linking the two tables is an easy way to solve the problem. Thank you very much for that hint.

Diana