Identify non imported/appended records

[Peter]

Hi all again,
How do I identify all records that did not become appended (because of
duplicate values) in a append query? I want to be able to use those
records..can I store them in a separate table?

Thanks!

 

[PieterLinden via AccessMonster.com]

Hi all again,
How do I identify all records that did not become appended (because of
duplicate values) in a append query? I want to be able to use those
records..can I store them in a separate table?

Thanks!

Create a query, add both tables to it, and join on the primary/foreign key
fields. The only records that show up will be the ones that are duplicated.

 

[Peter]

Thanks Pieter, will try your suggestions

Create a query, add both tables to it, and join on the primary/foreign key
fields. The only records that show up will be the ones that are duplicated.

--



.