Comparing fields in Access

[flames8889]

Hello,

In Excel, there is a logical function that compares two fields: =a1=b1. This returns a value of 'TRUE' or 'FALSE'. How does one do that same function in Access? I've tried using similar functions, using iif, everything I've tried either gives me an error message or returns a value of 0 (zero).

Thanks in advance.

[ajetrumpet]

iif is prolly the best. what do you want? display booleans based on a statement?

[TheShabz]

iif(mytable.record1 = mytable.record2, "TRUE", "FALSE")