G
Guest
I have a database field that stores numbers 1,2 and 3 representing different
values. In the form, I try to display the text value instead of the stored
numeric value. The statement is as follows:
=IIF([Type]=1,"Regular",IIF([Type]=2,"LumpSum","Special"))
but this won't work. Anyone know what's wrong with the above statement, I
followed the format from a textbook.
Thanks a lot.
values. In the form, I try to display the text value instead of the stored
numeric value. The statement is as follows:
=IIF([Type]=1,"Regular",IIF([Type]=2,"LumpSum","Special"))
but this won't work. Anyone know what's wrong with the above statement, I
followed the format from a textbook.
Thanks a lot.