IIF Statements

K

krc547

I have this already in place, but I need it to also look at the MotherBaby
Field and if it is checked then it over rides this and inputs a default of
$2256

Rate: IIf([Age]<=4,1589,IIf([Age] Between 5 And 8,1648,IIf([Age] Between 9
And 11,1697,IIf([Age] Between 12 And 14,1787,IIf([Age] Between 15 And
19,1865,0)))))
 
D

Dennis

Rate: IIf([MotherBaby]=True,2256,IIf([Age]<=4,1589,IIf([Age] Between 5 And
8,1648,IIf([Age] Between 9
And 11,1697,IIf([Age] Between 12 And 14,1787,IIf([Age] Between 15 And
19,1865,0))))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF Statement with a twist 1
Date Brackets as an IIf statement 3
Complex Switch Function or Maybe it should be IIF 2
IIF Statement to calculate aging buckets 7
Multiple IIf's 6
IIf statement vs Select Case statement 1
IIf Statement in Query Criteria 1
Iif statement and time format 2

Top