Remove Duplicate

[rgparpaccessforums]

Hi, Hope some one can help me.


I have two table: JPAPtlist (9000 records) and BillingPtlist (3000).
JPAPtList - ID (primarykey), LastName, FirstName, DOB, StreetAddress, City, Zip, State, and Ph
BillingPtList - ID(primaryKey), LastName, FirstName, DOB, Ph, SS, and BillingDate.

I want to find the duplicate record based on LastName, and FirstName between JPAPtList and BillingPtList. Then I want to keep only duplicate record of JPAPtList into new table - JPABillingPtList.

Thanks in advace.

[RuralGuy]

Have you tried the FindDuplicate query wizard yet?

[rgparpaccessforums]

Thanks for response. Duplicate query wizard only works for single table and not two table that I am interested.

[RuralGuy]

Between the FindDuplicates and FindUnmatched queries you should be able to put together the SQL you need for your query.