By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,499 Members | 1,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,499 IT Pros & Developers. It's quick & easy.

project start date should be less than project end date

P: 2
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.
Mar 18 '15 #1
Share this Question
Share on Google+
3 Replies


Seth Schrock
Expert 2.5K+
P: 2,951
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.
Mar 18 '15 #2

P: 2
it displays a message that'invalid sql syntax-cannot use multiple columns in a volumn-level CHECK constraint
Mar 18 '15 #3

Seth Schrock
Expert 2.5K+
P: 2,951
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.
Mar 19 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.