FINDING DUPLICATES

[SAM]

Hi
I have two table with 7 fields
Table A
01 02 03 10 11 12 13
01 03 10 22 23 25 26
05 06 50 56 59 89 90

table B
01 02 03 10 11 12 13
05 06 50 56 59 89 90
11 12 13 14 15 16 17

here I have records 1 and 2 same in both the tables I
want the query to show the records in Table A that are
not the same as in table b
thank you

 

[Jeff Boyce]

Check Access HELP on "unmatched query". There's even a query wizard to help
with this.

 

[Guest]

Thanks for your reply sir
I have tried using the help in access, it finds unmatched
records by compairing only one field either field1 to
field1 or field5 to field5, the kind of results I want is
to compare all the fields in both tables and get
unmatched records in Table A

 

[Jeff Boyce]

If you use the "unmatched query wizard" to provide the generic query, then
modify the query, you can use more than one field.

 

[Guest]

I have tried sir it doesn't work
thank you

 

[John Spencer (MVP)]

Add both tables to the query grid.

JOIN field1 to field1
JOIN Field2 to field2
etc.

Now click on each join line and select the option that gives you all records in
A and only those matching in b.

Now Select ANY one field from b and set its criteria to Is Null.

That should give you all records in A that don't have a match in B.