Hi !

Im fresh in MS access(MS Access 2000 premium) . I have a question ! How to find duplicate data between more table ? I have 8 tables ! For the duplicate wizard , can find duplicate in 1 table only ! How to do it in 8 table ?

Thanks !

From ,
jeremy(malaysia) :confused:

How you do this depends on what you want to do with the data. For example, are you trying to merge the recordsets in to a single table without duplicates?

How you do this depends on what you want to do with the data. For example, are you trying to merge the recordsets in to a single table without duplicates?

No ! I dont want merge it become 1 table , i have few table also contained name , address , telephone ... i just want to find out duplicate between this few table . I just want to find out duplicate name in few table only . how ?

Create a query that joins two tables on the fields that you want to examine for duplicates. Whatever rows are returned indicate that the value exists in both tables. So if you join on firstname to firstname and lastname to lastname and get no records returned, that tells you that the same combination of firstname and lastname does not exist in both tables.