Forum Discussion
Ganesh99
Jan 11, 2023Copper Contributor
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...
arnel_gp
Jan 11, 2023Steel Contributor
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")
- Ganesh99Jan 11, 2023Copper ContributorHello there!
Thanks for responding. I m using your inputs to enrich and try iterations.
Regards
Ganesh