Validation calculated values...

  • Thread starter Thread starter Tonio P.
  • Start date Start date
T

Tonio P.

Hi,

I created a database in Access 2000. I used validation
rule/text in some of my fields and i understand that it
will have an effect if you enter data on a validated field
but the problem is what if, if you use that particular
validated field in a query that has an expression/formula
is it possible that this calculated field will have an
effect? if so, how? i tried it already but i got a wrong
output.

thanks a lot.
 
You cannot use the name of a calculated field in a query as part of the
validation rule in a table.

You may be able to repeat the calcualtion itself in the table. If the rule
involves more than one field (e.g. [Quantity] * [UnitPrice] > 0), be sure to
use the Validation Rule for the table, not that of the field. In table
design view, the table's Validation Rule is entered into the Properties box,
not the lower pane of the table design window.
 
still it doesn't work. hope somebody can give some help.
thanks.
-----Original Message-----
You cannot use the name of a calculated field in a query as part of the
validation rule in a table.

You may be able to repeat the calcualtion itself in the table. If the rule
involves more than one field (e.g. [Quantity] * [UnitPrice] > 0), be sure to
use the Validation Rule for the table, not that of the field. In table
design view, the table's Validation Rule is entered into the Properties box,
not the lower pane of the table design window.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Tonio P. said:
I created a database in Access 2000. I used validation
rule/text in some of my fields and i understand that it
will have an effect if you enter data on a validated field
but the problem is what if, if you use that particular
validated field in a query that has an expression/formula
is it possible that this calculated field will have an
effect? if so, how? i tried it already but i got a wrong
output.

thanks a lot.
Click to expand...


.
Click to expand...
 
Back
Top