IIF statement to compare two fields.

[E-mail report using Lotus Notes rather t]

Hi,

I would like to use the IIF statement to compare two fields in Access query
design view. I would like to compare two fields in a query. I know how to
do it in Access using IF statement (i.e. IF(A1=A2, "Yes","No"). Please tell
me how to write an IIF statement in Access to compare two fields. Thank you.

Regards.

 

[KARL DEWEY]

In design view in Field row blank use this with your actual field names --
My_IIF_Results: IIF([Field1] = [Field2], "Yes", "No")

 

[Jerry Whittle]

CompareFields: IIf([Field1]=[Field2],"Yes","No")

However you have to watch out for nulls.

Debug.Print IIf(Null = Null,"Yes","No") will return No even though they are
both nulls.