|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 16th, 2007, 08:06 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Using "AND" in an IIF function statement
This is what I am trying to do:
I have two conditions that I want the if statement to look at. If my CF_Premium is greater than 0 and my FLS_Premium is less than 0, add the two values. This is what I tried first and I get an error message: Premium_Variance:IIF(and([CF_Premium]0,[FLS_Premium]0),[CF_Premium]+ [FLS_Premium],IIF(and([CF_Premium]0,[FLS_Premium]0),[CF_Premium]+ [FLS_Premium],0)) Then I tried this: Premium_Variance:IIF([CF_Premium]0 and [FLS_Premium]0,[CF_Premium]+ [FLS_Premium],IIF([CF_Premium]0 and [FLS_Premium]0,[CF_Premium]+ [FLS_Premium],0)) 
|
|
#2
February 16th, 2007, 08:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Using "AND" in an IIF function statement
If my CF_Premium is greater than 0 and my FLS_Premium is less than 0, add
the two values. IIF([CF_Premium]0 and [FLS_Premium]0,[CF_Premium]+[FLS_Premium],0) "AMFLMSC" wrote: This is what I am trying to do: I have two conditions that I want the if statement to look at. If my CF_Premium is greater than 0 and my FLS_Premium is less than 0, add the two values. This is what I tried first and I get an error message: Premium_Variance:IIF(and([CF_Premium]0,[FLS_Premium]0),[CF_Premium]+ [FLS_Premium],IIF(and([CF_Premium]0,[FLS_Premium]0),[CF_Premium]+ [FLS_Premium],0)) Then I tried this: Premium_Variance:IIF([CF_Premium]0 and [FLS_Premium]0,[CF_Premium]+ [FLS_Premium],IIF([CF_Premium]0 and [FLS_Premium]0,[CF_Premium]+ [FLS_Premium],0))
|
|
#3
February 16th, 2007, 08:59 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Using "AND" in an IIF function statement
Thanks!
|
|
#4
February 17th, 2007, 08:25 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Using "AND" in an IIF function statement
Your first solution is an Ecel notation for AND -- and(varA,VarB,..VarN) and
does not work in VB. However, your second solution is correct only it adds the 2 numbers together regardless if: CF_Premium 0 AND FLS_Premium 0 *** OR *** CF_Premium 0 AND FLS_Premium 0 Josh D "AMFLMSC" wrote: This is what I am trying to do: I have two conditions that I want the if statement to look at. If my CF_Premium is greater than 0 and my FLS_Premium is less than 0, add the two values. This is what I tried first and I get an error message: Premium_Variance:IIF(and([CF_Premium]0,[FLS_Premium]0),[CF_Premium]+ [FLS_Premium],IIF(and([CF_Premium]0,[FLS_Premium]0),[CF_Premium]+ [FLS_Premium],0)) Then I tried this: Premium_Variance:IIF([CF_Premium]0 and [FLS_Premium]0,[CF_Premium]+ [FLS_Premium],IIF([CF_Premium]0 and [FLS_Premium]0,[CF_Premium]+ [FLS_Premium],0))
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
