Warranty Yes/No w/ Total Box

[Bike]

I have a form with a [Total] box that calculates from a [Job Length in Hours] field(at the rate of 85$/hr) field but i have a warranty Yes/No field also.

My question is that how would i go about creating it so that, if the warranty box is checked yes, that the total will automatically be zero, but if its not checked it will be its regular, 85$/hr rate.

This is my current control source for my total box:

"=[Job Length]*85"





Thanks.

[pbaldy]

Along the lines of

=IIf(Warranty = True, 0, [Job Length]*85)

[Bike]

Got it working, thanks a lot. You've been a great help with everything.

Solved.

[pbaldy]

Happy to help.