Arthur Fuller
fuller.artful at gmail.com
Mon Jan 16 17:43:08 CST 2012
Of course that can't work. The part after the OR resolves to a Boolean. What you want is more like this: [overtime]=Iif( [hours worked]>40, [hours worked] - 40, 0) HTH, On Mon, Jan 16, 2012 at 6:03 PM, Susan Harkins <ssharkins at gmail.com> wrote: > No, I tried something similar too. > Susan H. > > Hi Susan >> >> Does this do what you want? >> [overtime]=0 Or [hours worked]>40 >> >> Regards >> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd> > Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> > -- Arthur Cell: 647.710.1314 Prediction is difficult, especially of the future. -- Neils Bohr