asked on Nested If
Experts, I get the wrong number of arguments error in the below. I dont know if I can do what I am trying to do. Let me know if you see a comma misplaced or a parenth or if my logic is completely off on this one.
=iif(Nz([PastDueYN],"")=""
=iif(Nz([PastDueYN],"")=""
Microsoft Access
Last Comment
pdvsa
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
lets evaluate what you are trying to do
for the first IIF expression
=iif(Nz([PastDueYN],"")=""
if the expression is True, what value do you want to show in the <whatValue> portion
for the first IIF expression
=iif(Nz([PastDueYN],"")=""
if the expression is True, what value do you want to show in the <whatValue> portion
ASKER
Nice! I have to put on my glasses. Tough to see all of those parenth and commas.
thank you
thank you
=iif(Nz([PastDueYN],"")=""
Saurabh...