Easy IFF question....I hope

[REDaughdril]

I have a form that I has a password field that matches the employee name. I want the employee to enter in a data field their password. If it matches I want another field (verified) (yes/no field) be marked as yes if it matches and no if does not.

I did IFF([Text5]=[Password],[Verified],= -1, [Verified]=0]

But it didn't work. Any suggestions.

Thanks for the help

 

[raskew]

Hi -

The function is Iif(), Immediate If(), not iff(). See if that works any better for you.

Bob