Error In IIF Loop

[Eranka]

Hi All

IIf(([Session_ID]="Evening") And (([Time_Out]-[Time_In])*24)>=3,0.125,([Time_Out]-[Time_In])) AND IIf((([Time_Out]-[Time_In])*24)>=4,0.166666666,([Time_Out]-[Time_In])) AND IIf(([Level_Of_Unit]="F0") And (([Time_Out]-[Time_In])*24)>6,0.25,([Time_Out]-[Time_In]))

I tried above code. its not working. How to correct this and get as below mentioned formula.

i want to run the loops separate. Like Below

IIF([Expression],[True],[False]) AND IIF([Expression],[True],[False]) AND IIF([Expression],[True],[False])

[Minty]

What do you think the result of that would be? Break it out and you will get something like

3 And 4 And .25

Which makes no sense.
You would be better writing these complicated types of If statements into a function - pass in the fields you need to check and call that in your query.

[June7]

Perhaps you are looking for nested IIf() : IIf([expression], True, IIf([expression], True, IIf([expression], True, False)))

IIf([Session_ID]="Evening" And ([Time_Out]-[Time_In])*24>=3, 0.125, IIf([Level_Of_Unit]="F0" And ([Time_Out]-[Time_In])*24>6, 0.25, IIf(([Time_Out]-[Time_In])*24>=4, 0.166666666, [Time_Out]-[Time_In])))

[Eranka]

Thnks alot for your support guys,