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.