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

Student Date of Birth Validation in Microsoft Access 2000

P: 2
Hi, I'm an A2 ICT student in second year of college right now and I am working on my database project as my coursework. Its about a dance school with 4 tables Student, Class, Teacher and Enrolment.

I am stuck on the validation for the Student's Date of Birth field. I have figured out that this field has to be:

less than today's date and the student has to be in range of 3 and half to 80 years old.

If anyone knows the answer, please reply on this thread as soon as possible as my deadline is in 2 weeks for the design, thanks a lot

JKChan
Dec 9 '07 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
Are you using any front end tool or only designing the database ?
Dec 10 '07 #2

P: 2
Are you using any front end tool or only designing the database ?
Hi,

Thanks for replying,
What do you mean by a front end tool? I just have to use Access to design and implement the database. I'm not familiar with any programming language as such, I just use simpler validation, A2 level.

JKChan
Dec 10 '07 #3

Post your reply

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