469,927 Members | 1,995 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Student Date of Birth Validation in Microsoft Access 2000

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
2 1564
debasisdas
8,127 Expert 4TB
Are you using any front end tool or only designing the database ?
Dec 10 '07 #2
JKChan
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.

Similar topics

4 posts views Thread by Richard Hollenbeck | last post: by
16 posts views Thread by KL | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.