Comparing two tables

[Guest]

I have a database consisting of two tables. Table 1 is Field Review, Table 2
is IAD Review. Each table contains approximately 25 fields and the structure
of each table is identical. I would like to generate an exception report
that identifies and lists those records that have any field that does not
match exactly between the two tables. Does anyone have any suggestions on
the best way to structure this?

 

[Guest]

Use the unmatched query wizrd

 

[aaron.kempf]

or you can use the CHECKSUM function.. CHECKSUM(*)

that would only work in an Access Data Project though; MDB is for
babies and it doesn't have the basic tools necessary to keep trakc of
these things

-Aaron

 

[Guest]

Thanks for the info.

This only seems to work for one specific field. Is there an easy way to
build the same type of query that identified unmatched entries for all 25
fields?

 

[aaron.kempf]

checksum(*) works like a charm buddy


SQL Server x Access Data Projects = BIGGER, BADDER, CHEAPER, FASTER

-Aaron