Steve Schapel
steve at datamanagementsolutions.biz
Mon Jan 16 17:53:12 CST 2012
Hi Susan Ah, ok. I had originally assumed that your Hours field would be total hours including overtime. If it's non-overtime hours, and goes to a max of 40 before the overtime kicks in, then that now looks right: [overtime]=0 Or [hours]=40 Regards Steve -----Original Message----- From: Susan Harkins Sent: Tuesday, January 17, 2012 12:17 PM To: Access Developers discussion and problem solving 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