[AccessD] Go it... Re: Simple record-level validation rule

Susan Harkins ssharkins at gmail.com
Mon Jan 16 17:17:26 CST 2012


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 



More information about the AccessD mailing list