[AccessD] Simple record-level validation rule

Steve Schapel steve at datamanagementsolutions.biz
Mon Jan 16 18:15:47 CST 2012


Hi Arthur

It isn't trying to assign any result.

The Rule that Susan ended up with is:
[overtime]=0 Or [hours]=40

That's a total expression that evaluates to True or False.
([overtime]=0 Or [hours]=40)

It's True if [overtime]=0, or if [hours]=40.
It's False with other combinations of values for these two fields, the 
Validation Rule fails, and presumably a Validation Text is shown.
So in practice (as I understand it) the Rule will evaluate to False if:
[overtime]>0 And [hours]<40

Regards
Steve

-----Original Message----- 
From: Arthur Fuller
Sent: Tuesday, January 17, 2012 12:57 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Simple record-level validation rule

But why is it trying to assign the result to the Overtime field?

On Mon, Jan 16, 2012 at 6:50 PM, Steve Schapel <
steve at datamanagementsolutions.biz> wrote:

> Arthur
>
> This is a Validation Rule ... it's *supposed* to resolve to a Boolean. :)
>
> Regards
> Steve
>



More information about the AccessD mailing list