Hi,
I need to perform a quality control check between an original report and the same report produced by a new process. Specifically i want to check that both versions of the report are identical across all columns and rows. The original report is held in a table "OR1" and the new report is in table "NR1".

In Oracle I would use:

(SELECT * -- list all rows in original report but not in new report
FROM OR1
MINUS
SELECT *
FROM NR1)
UNION ALL -- appended to
(SELECT * -- all rows in new report but not in original report
FROM NR1
MINUS
SELECT *
FROM OR1)

There will be zero rows output if both tables are identical.

How do I perform this check using Access 2002? (Please note that I need to check all 50 columns and not just the primary key.)