Iff statement

[PeterK]

I am trying to use an "If" statment in a report but having
no luck.

Example: =iff([Temperature]="1", "Hot", "Cold")

Any suggestions?

THX

 

[Les]

It should be IIF instead of iff.

 

[Peter Cole]

Try IIF as otherwise it's ok
Peter C