Validation rule

  • Thread starter Thread starter Stefano Fea
  • Start date Start date
S

Stefano Fea

Hi everybody,
I have a database with a table including lots
of fields, and I would like to implement a validation rule
working like this: the date in the "date of spedition"
field must be > or = to the one in the "date of request"
field.
In the validation rule's box in the table structure's
section I wrote like this
"Date of Request" OR is null
Click to expand...
Let's say date of request is the name of the field.And it
is not working, probably because it reads date of request
as a value, not as a field. What should I do to make
Access realise that what I mean is the value inside a
field in the same record? Is it possible and feasible?
Thanks a lot
Regards
 
try this and it will read as a field:
[Date of Request] Or Is Null
Rich

-----Original Message-----
Hi everybody,
I have a database with a table including lots
of fields, and I would like to implement a validation rule
working like this: the date in the "date of spedition"
field must be > or = to the one in the "date of request"
field.
In the validation rule's box in the table structure's
section I wrote like this
"Date of Request" OR is null
Click to expand...
Let's say date of request is the name of the field.And it
is not working, probably because it reads date of request
as a value, not as a field. What should I do to make
Access realise that what I mean is the value inside a
field in the same record? Is it possible and feasible?
Thanks a lot
Regards
.
Click to expand...
 
Back
Top