Multiple Validation Rules

[Guest]

I have a form with a number of fields that dump data into Table A. I need a
number of validation rules within the form to ensure that dates cannot be
entered incorrectly. I can get one of these rules to work in the validation
section for the table itself, but not more than one. I need to create all
four of these somewhere!

Create a validation rule to prevent Episode End < Episode Start
Create a validation rule to prevent Discharge Date < Admission Date
Create a validation rule to prevent Episode Start < Admission Date
Create a validation rule to prevent Discharge < Episode End Date

If I try and put the validation rules against each field in the table, I get
a 'Invalid SQL Syntax' error.

 

[Brendan Reynolds]

You need to use the 'And' keyword between each validation rule ...

([Episode End] < [Episode Start]) And ([Discharge Date] < [Admission Date])
And ([Episode Start] < [Admission Date]) And ([Discharge] < [Episode End
Date])