Bill Patten
bill_patten at embarqmail.com
Mon Jan 16 17:42:59 CST 2012
Hi Susan, Since it would appear that they do not get OT until they have worked 40 hours I would use if Hours <= 40 then OT = 0 Course some states and employers pay over time if they work more than 8 hours in a day and you need a more complex formula for that. Bill -------------------------------------------------- From: "Susan Harkins" <ssharkins at gmail.com> Sent: Monday, January 16, 2012 3:17 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Go it... Re: Simple record-level validation rule Shoot!!! ([overtime]=0) Or ([hours]=40) I'm still kind of puzzling out how it works, but it does -- so far. I guess it's that 40 cutoff that was confusing me -- the only way you'll have an overtime value is if hours is exactly 40 -- so it makes a bit more sense to me now. I was hung up on the less thans and greater thans. Susan H. > ([overtime]<0) Or ([hours]=40) > > Thanks! > Susan H. > >> 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 > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com