My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Iff
|
|
 Nov 16 2005, 09:16 AM
Post
#1
|
|
|
New Member Posts: 4  |
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
Post
#2
|
|
|
Utter A-fishin'-ado Posts: 17,723 From: Cincinnati, Ohio, USA . . . ><((((°> |
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
Post
#3
|
|
|
New Member Posts: 4 |
Thanks!!!!!!
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
Post
#4
|
|
|
Utter A-fishin'-ado Posts: 17,723 From: Cincinnati, Ohio, USA . . . ><((((°> |
So, do you need further assistance??
|
|
|
|
|
Nov 16 2005, 09:25 AM
Post
#5
|
|
|
UtterAccess VIP Posts: 23,583 From: Mississippi |
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") |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 24th May 2013 - 12:20 PM |