[AccessD] Simple record-level validation rule

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


More information about the AccessD mailing list