[AccessD] Simple record-level validation rule

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 



More information about the AccessD mailing list