Append on criteria but show duplicates

[bunji]

I have created my append query (qry1) that works fine, but would like it to check to see if an entry may already exist in tbl2 based on three fields.
(CompanyName, FirstName, Surname)

I would then like to show the ones that aren't appended because of duplicates, but append the rest.

Can this be done?

 

[Jibbadiah]

You could put your primary key on those 3 fields to only append records that aren't dupes.

If you want to view the dupes first run a "find duplicate" query against query1 first.