Access can't parse expression

[dbar10]

I am writing a macro to SetValue in a field on my form. This will activate on the AfterUpdate event from the Verify checkbox. I believe this to be the expression I want but, for the life of me I can't get the syntax right. I've tried so many different combinations. I just keep getting the error: Access can't parse the expression. I think I'm brain dead. Can you help?


IIf([TextOTCalc])+[TextHoursWorked]<=40,0,IIf([TextOTCalc]+[TextHoursWorked]>40,[TextOTCalc]+[TextHoursWorked]-40-[TextNowOT],0))

 

[randy700]

how about...

IIf([TextOTCalc]+[TextHoursWorked]<=40,0,IIf([TextOTCalc]+[TextHoursWorked]>40,[TextOTCalc]+[TextHoursWorked]-40-[TextNowOT],0))

Randy

 

[dbar10]

Thanks randy, I see it now