Double records in 9 tables

[Guest]

Hello
I got 9 tables in MS Access 2003 and each table have more then 2000 entries.
My task is find out double records in two columns of 9 tables. for example in
each table column 1 DOB (Date of Birth) has 6 zero(mm.dd.yyyy) and column 2
ID has 5 zero (12345). Now my task is find out that Table A has double record
with Table B, Table C, Table D ..... individually and collective in both
columns (DOB & ID). I find out solution for individually but need help for
collective. Report will be show in this formate or ....?

RNo Table A Table B Table C Table C Table D
1 DOB ID x x
2 DOB ID x x
3 DOB ID x x x x
4 DOB ID x x

wher RNo=Record No, x=shows double record with Table A.

I hope that i will get answer from you. Best regards and thanks for your help.

 

[G. Vaught]

Try creating a duplicates query.

 

[John Vinson]

Hello
I got 9 tables in MS Access 2003 and each table have more then 2000 entries.
My task is find out double records in two columns of 9 tables. for example in
each table column 1 DOB (Date of Birth) has 6 zero(mm.dd.yyyy) and column 2
ID has 5 zero (12345). Now my task is find out that Table A has double record
with Table B, Table C, Table D ..... individually and collective in both
columns (DOB & ID). I find out solution for individually but need help for
collective. Report will be show in this formate or ....?

RNo Table A Table B Table C Table C Table D
1 DOB ID x x
2 DOB ID x x
3 DOB ID x x x x
4 DOB ID x x

wher RNo=Record No, x=shows double record with Table A.

I hope that i will get answer from you. Best regards and thanks for your help.

If TableA is the "master" table you can simply create a Query joining
TableA to each of the other tables, joining by RNo and by DOB. Select
each of the sixteen join lines (from TableA to each of the other
tables) and select option 2 - "Show all records from TableA and
matching records from <the other table>".

The need to do this is a good example of why it's a bad idea to have
multiple tables for the same kind of data! You may want to run Append
queries to migrate all nine tables into one.

John W. Vinson[MVP]