Compare fields in Access

Please clarify that you are comparing columns in your Access DB tables.  Also, what nz function are you referring to?  (the return value one?)  What is the error/issue you are having?  

I'm comparing columns in my access tables. I need to compare data of old vs. new. and I need to see any differences that occurred.

nz([AFTER].[01]))<>([BEFORE].[1])

I'm just unsure if this is the best way to go. I need to compare each column within the table.

Nz(After,0)<>Nz(Before,0)

BTW, I've found Nz() is very reliable - however, I can't say the same for some of the users ;-)

I assume you are looping through result sets using NZ.  But would a query work for you?

select * from before B, after A where B.fld2Compare != A.fld2Comapare

Oh, and you need a key...

select * from before B, after A where B.fld2Compare != A.fld2Comapare  and B.key = A.key

'!=' doesn't fly in Access.  

In the Immedidate Pane:

? 1<>2
True
? 1!=2
False

Can I perform an outer join with it too? I would like value that do not exist New but existed in the Old

Thanks

I also noticed that in the before its lowercase and uppercase in the after.

How do I add the UCASE function to the NZ function?

Thanks

I figured out the rest, thank you

Thanks, glad to help.