Im trying to put in the Validation rule for the date field like [Delivered Date]<[Received Date] but it comes out like a syntax error and something to do with the columns.

In the actual table def you can only use patterns or constants for the
validaton rule. It just won't work if you try to used field names.

You have 2 options.
You can set a validation rule in code. You would just have to run the
code once. A sample of the code is in the help file. Just press F1
while the curser in validation and you will find the code in the last
example.

Or

If you are using a form you can use the afterupdate event to check for
a valid condition.

Good luck

Ira Solomon

On Fri, 14 Jul 2006 14:14:58 -0500, Sarai
<Sarai.2ayb9z (AT) no-mx (DOT) forums.yourdomain.com.au> wrote: