Validation Rule for table field
Posted on 2008-10-07
I have created an Access table for contracts that has two fields identifying the (contract) start date and the (contract) end date. I thought I could have a validation in the table design for the "end date" that says < "start date", but it doesn't seem to want to let me do this. The error (though cryptic to me) say:
"Invalid SQL Syntax - Can't use multiple columns in a column-level CHECK constraint".
What have I done wrong, and how can I make that validation? Thanks. - Tom