I have two tables with 9 columns (fields) each. I want to cross-check
each table against the other to see what rows appear with all 9 fields
matching in the other table. (i.e. discrepency comparison).

I'd also like to flag which fields are not matching between the two
tables. There are no unique fields out of the 9. (i.e. I can't just
match a number in one table and compare the remaining fields ... any
field may have the same value for several rows).

Anyone have any ideas on how to do a multiple field comparison when
there is not a unique field?

I can write a macro, but thought I'd get some ideas first...

Thanks!

John