If then ??

[trackmedic]

Hi,

I would like to place an unbound box on a form to show the words "Time Violation" if the following is true between two fields on the form.

if "total hours worked" > "total hours rest"

Can someone help me with the syntax for this?

As always, thanks in advance!

 

[pbaldy]

Try

=IIf([total hours worked] > [total hours rest], "Time violation", "")