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))))))
 
Top