Nov 16 2005, 09:16 AM
Are you able to nest IIf statements just like in Excel?
What I am trying to do is build a column in a query that looks at more than one column then kicks out a TRUE or FALSE. For instance, Column 1 = Jan, Column 2 = Feb, Column 3 = March. I need to build a formula that looks at the 3 columns and if the all three are showing a 0, then "YES", otherwise "NO".
Nov 16 2005, 09:20 AM
Yes. You can nest IIf's 7 layers deep. Check the Access Help files for syntax.
...and Welcome to UA!
I just re-read your post. This can be accomplished with only 1 IIf.
Edited by: niesz on Wed Nov 16 9:21:09 EST 2005.
Nov 16 2005, 09:22 AM
I am a certified excel expert and just started playing with access a week ago so bare with me...
I tried help but couldnt find this syntax.
Nov 16 2005, 09:23 AM
So, do you need further assistance??
Nov 16 2005, 09:25 AM
Iif([Jan] = 0 AND [Feb] = 0 AND [March] = 0, "Yes", "No")
If any could be NULL then you will want the Nz to convert NULL to 0.
Iif(Nz([Jan],0) = 0 AND Nz([Feb],0) = 0 AND Nz([March],0) = 0, "Yes", "No")
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here