HELP!!!!!! Validation Rules

[fenerfan]

Hey All,

I have to attributes in my table, [Date1], and [Date2] , I need to add a validation rule to ensure [Date1]< [Date2],

I am trying to do this in design view
using the validation rule under date1 properties (I put in - <[date2] )

but It keeps coming up with errors When I try to save. Something to do with a column level check constraint.........

PLEASE, Can anybody help me?????

 

[stopher]

You can't use field names in the validation rules for individual fields. You must do this kind of thing at table level.

In table design, click View-Properties (or right click somewhere in the table and select Properties). Here you'll see the Validation Rule for the table. Enter [Date1]<[Date2] and add some validation text.

If you have complex validation, it's often better and more controlled to do it in the Form (note that users should only be allowed to enter data via a form and not directly into a table for query)

hth
Stopher