Steve Schapel
steve at datamanagementsolutions.biz
Mon Jan 16 17:50:20 CST 2012
Arthur This is a Validation Rule ... it's *supposed* to resolve to a Boolean. :) Regards Steve -----Original Message----- From: Arthur Fuller Sent: Tuesday, January 17, 2012 12:43 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Simple record-level validation rule 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com