C chrisguk Registered User. Local time Today, 05:19 Joined Mar 9, 2011 Messages 148 Aug 19, 2011 #1 How would I make this following code an IF OR statement? Code: Code: =IIf([Sum1]+[Sum2]+[sum3]=3,"Sorry this is not a valid claim","Valid Claim") So the Or would be [Sum1]+[Sum2]+[sum3]+[sum4]
How would I make this following code an IF OR statement? Code: Code: =IIf([Sum1]+[Sum2]+[sum3]=3,"Sorry this is not a valid claim","Valid Claim") So the Or would be [Sum1]+[Sum2]+[sum3]+[sum4]
M MStef Registered User. Local time Today, 13:19 Joined Oct 28, 2004 Messages 2,250 Aug 19, 2011 #2 Not IIF but IF function. Look at "DemoCalculationA2000.mdb" (attachment, zip). Open Form1 and try, (look at VBA). Adapt it as you need. Attachments DemoCalculationA2000.zip DemoCalculationA2000.zip 12.3 KB · Views: 102
Not IIF but IF function. Look at "DemoCalculationA2000.mdb" (attachment, zip). Open Form1 and try, (look at VBA). Adapt it as you need.
