Compare Many Columns in 2 tables 1

[manguilla]

Hello All. I have a problem comparing multiple columns between 2 tables. I have 2 Identical tables with 29 Columns. There is one row of data in the first table that I will be comparing to one row of data in the other table. I need to find a way to compare each column and find out if the data has changed. I am using Access 2003 so I know there is a limit to the "OR" statements I can use. Is that true? Any help will do. Thank you in advance.

Manguilla

 

[PHV]

Why not using a negative test ?
NOT ( a=x AND b=y AND c=z )
is the same as:
( a<>x OR b<>y OR c<>z )


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[manguilla]

Thanks PHV that worked great. It took a while but it looks good.

Manguilla