Identify non imported/appended records

  • Thread starter Thread starter Peter
  • Start date Start date
P

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!
 
Thanks Pieter, will try your suggestions

PieterLinden via AccessMonster.com said:
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.

--
Message posted via AccessMonster.com


.
Click to expand...
 
Back
Top