unmatched query

[DD]

i have two tables i would like to compare data to. the fields i need to
compare are date,shift,line,size. is there a way that i can compare all
these fields at once to another table. for example date - 06/04/07,
shift - 1, line - retail, size - 16 oz. now if my other table has the same
info except for size 16 oz. i want it to display in a query. my thought
was to merge all the fields together in one field and then compare those
fields. is this the best way to do this.

thanks

 

[John W. Vinson]

i have two tables i would like to compare data to. the fields i need to
compare are date,shift,line,size. is there a way that i can compare all
these fields at once to another table. for example date - 06/04/07,
shift - 1, line - retail, size - 16 oz. now if my other table has the same
info except for size 16 oz. i want it to display in a query. my thought
was to merge all the fields together in one field and then compare those
fields. is this the best way to do this.

thanks

No, it's not.

You can create a query joining two tables on up to TEN fields. For an
unmatched query, join all the fields that you want to compare; select *each*
join line and choose Option 2 (or 3) - "show all records in <first table> and
matching records in <second table>."

Put a criterion of

IS NULL

on any field in the second table. The query will now show you those records in
the first table which do not have an exact match in the second table.

John W. Vinson [MVP]