A
Andrew
Hi All,
I have a quick question. I hope someone can help.
I have an access database with a tbale in there called "DM Patient Tracking".
In this table there are 3 fields called [Unreviewed Discrepancies], [Passive
Review Discrepancies], and [Inv Review Discrepancies], all of which are
numeric fileds with default values of 0.
I have a forth field call [Data Review Complete] which I want populated (no
user input) with a logical "Yes/No" value as the field is set up that way.
This field also have a default value of "No".
I have loaded the following code into the Validation Rule in the Table
Properties.
"IIf(Eval([Unreviewed Discrepancies]=0 And [Passive Discrepancies]=0 And
[Inv Review Discrepancies]=0),[Data Review Complete]="Yes",[Data Review
Complete]="No")"
What I am getting, when I try to run the Test Validation Rules is an error,
as below.
"Unknown function 'Eval' in validation expression or default value on 'DM
Patient Tracking'.
What is wrong here. the code looks sound, and the rule for using IIF and
comparison operators (And, Or), is to use the Eval() function.
Please help.
I have a quick question. I hope someone can help.
I have an access database with a tbale in there called "DM Patient Tracking".
In this table there are 3 fields called [Unreviewed Discrepancies], [Passive
Review Discrepancies], and [Inv Review Discrepancies], all of which are
numeric fileds with default values of 0.
I have a forth field call [Data Review Complete] which I want populated (no
user input) with a logical "Yes/No" value as the field is set up that way.
This field also have a default value of "No".
I have loaded the following code into the Validation Rule in the Table
Properties.
"IIf(Eval([Unreviewed Discrepancies]=0 And [Passive Discrepancies]=0 And
[Inv Review Discrepancies]=0),[Data Review Complete]="Yes",[Data Review
Complete]="No")"
What I am getting, when I try to run the Test Validation Rules is an error,
as below.
"Unknown function 'Eval' in validation expression or default value on 'DM
Patient Tracking'.
What is wrong here. the code looks sound, and the rule for using IIF and
comparison operators (And, Or), is to use the Eval() function.
Please help.