Forum Discussion
iif statement in Access DB
Hi all, I m unable to get my iif statement right. I have a table Dec 22 in which 2 columns are SO and Description. Say if I want a True if the values in SO = Description and otherwise a False. H...
you may try:
T/F: IIF((NZ([SO], "@") = NZ([DESCRIPTION], "#")), "TRUE", "FALSE")
but the question, what if both are Null are they equal to you?
if they are, use this:
T/F: IIF((NZ([SO], "@") = NZ([DESCRIPTION], "@")), "TRUE", "FALSE")
T/F: IIF((NZ([SO], "@") = NZ([DESCRIPTION], "#")), "TRUE", "FALSE")
but the question, what if both are Null are they equal to you?
if they are, use this:
T/F: IIF((NZ([SO], "@") = NZ([DESCRIPTION], "@")), "TRUE", "FALSE")
- Hello there!
Thanks for responding. I m using your inputs to enrich and try iterations.
Regards
Ganesh
