Validation rule

[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

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

 

[Rich]

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

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
.