project start date should be less than project end date

[maslo95]

Hello I am stuck with a problem and I need some help.I have been asked to make the Project_Start_Date less than the Project_End_Date of my project_details table and before a project is assigned today employee a check should be performed ro ensure that the start date of the new project is greater than the end date of the current project to which that employee has been assigned.please someone kind enough can help me.

[Seth Schrock]

I'm guessing that you enter the start date before the end date, so I would put data validation in your End Date field to say >= [Project_Start_Date]. You would go into design view on your table and select your end date field and look in the field properties to see your validation property.

[maslo95]

it displays a message that'invalid sql syntax-cannot use multiple columns in a volumn-level CHECK constraint

[Seth Schrock]

Checkout the following link: Validation Rules. In the section titled Validation Rules for tables, you will see an example of what you are looking for.

Just making sure, are you using Access as your backend or some SQL server? The error message seems more like a MySQL, SQL Server or Oracle message than it does like Access.