Date/time Fields, Validation Rule "invalid SQL Syntax - Cannot Use Multiple Columns

[muhijo]

Using: Access 2007



Hi,

1) Should be a simple question: I want to set a validation rule for two fields (Date/Time). Both input masks are "99.99.00;0;_". Always error "Invalid SQL syntax - cannot use multiple columns in a column-level CHECK constraint." if i wanna save the table.

([Enddate] Is Null) Or ([Enddate]>=[Startdate]). Enddate should either left blank or should not before the enddate. Where is my fault?


2) I want to set a validation rule which allows [Field1] (text) if [Field2] is set "No" (Yes/No Type) no entry in [Field3] (Number). If [Field2] is set "Yes", an entry in [Field3] is possible.

Hope you can help me.

best regards,
muhijo

[pbaldy]

I don't know that you can do those with a validation rule. I'd use the before update event of a form:

http://www.baldyweb.com/BeforeUpdate.htm