Comparing 2 datasets

[fhickler]

I have 2 tables of contact info joined by an id number field. My goal is to compare each field in one table with its corresponding field in the other, and let me know whether or not they are equal. The way I've achieved this is to make a query the looks like this:

Address_line_1	Address_Line_1	CompareAdd1:[Table1].[Address_line_1]=[Table2].[Address_Line_1]
Table1	Table2

with a set of 3 columns for each field that I want to compare. Is there a better way to achieve this that someone can recommend? I prefer not to do much coding in sql or vbscript, as my scripting skills or not great, and my Access skills in general are kinda intermediate.

Thanks in advance.

[pbaldy]

That's how I would do it, barring other requirements. Generally SQL is the most efficient way to pull data.