Newbies bstretch Posted January 24, 2001 Newbies Share Posted January 24, 2001 Dear All I developed a database for a school athletics team about 6 months ago which they have put to great use and got a lot out of it. It is a relational database, with seperate files for Athlete Information, results, etc. The date of birth (DOB) of all 170 odd athletes is entered in the database in an appropriate field. What I need to be able to do, is make a script to take this DOB information and classify athletes into age groups as follows: Under 13, Under 14, U15, U16, U17 and Opens. Basically, I want to be able to specify a particular cut-off date (for exampe, 30th May) and have the script work out which age bracket each athlete fits into. I probably havn't explained this exceptionally well but with any luck someone will know what I'm looking for. If anyone needs more information I'd be more than happy. I hope someone can help with this issue! Regards Ben. Link to comment Share on other sites More sharing options...
Chuck Posted January 24, 2001 Share Posted January 24, 2001 You don't need a script, although you could do it with one. A calculation will do the trick. Case( Link to comment Share on other sites More sharing options...
Newbies bstretch Posted January 24, 2001 Author Newbies Share Posted January 24, 2001 OK, thanks Chuck. I'll give it a go and see if I can modify it to implement the cut-off dates. Thanks for your help, Regards Ben. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8486 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now