validation rule invalid?

[dindigul]

Access online help says"
For example, you could define the validation expression
"[RequiredDate]<=[OrderDate]+30" to make sure that the date entered into the
RequiredDate field is within 30 days of the date in the OrderDate field.

However when I enter the same in the "todate" field as
[todate]<=[fromdate]+30 I get message invalid SQL Syntax, cannot use
multiple columns - in a column level check constraint.

Who is correct Access or Microsoft?

 

[RoyVidar]

Access online help says"
For example, you could define the validation expression
"[RequiredDate]<=[OrderDate]+30" to make sure that the date entered into the
RequiredDate field is within 30 days of the date in the OrderDate field.

However when I enter the same in the "todate" field as
[todate]<=[fromdate]+30 I get message invalid SQL Syntax, cannot use
multiple columns - in a column level check constraint.

Who is correct Access or Microsoft?

When in design view of the table, fetch the properties dialog (hit
Alt+Enter). When you use that, you will get row level validation,
i e, be able to refer to other columns in the same row.