Year of Education

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which childrens' dates of birth and I can work out their age
but can anyone help me work out their year of education in the UK. ie
whether they are in year 1-12 in school?
 
Caroline,
Well, if it's like the US, kids that are 5 OR 6 can be in the 1st grade,
depending on their year/month of birth, so you'll need to develope some
rules as to how the YearInSchool is calculated.
Ex. "If the Month of DOB = something then yada yada..."
When you can provide us with a "verbal description" as to how to
determine whether a child enters school at 5 or 6, we'd only be guessing as
to how to do it.
But... if you can say that all kids 6 years old are in Grade 1, then
simply...
ChildAge - 5 = YearInSchool.
hth
Al Camp
 
I have a form which childrens' dates of birth and I can work out their age
but can anyone help me work out their year of education in the UK. ie
whether they are in year 1-12 in school?
Click to expand...

How would you work it out in real life? I'm not familiar with British
educational systems; is a child in first grade typically 6 years old,
or what? What is the cutoff date?

Another complication is that - at least in the US - some children may
be held back a year if they're not prepared for school at the default
starting age, and other kids may skip a grade if they're particularly
quick at learning. Someone in 8th grade might be anywhere from 12 to
15, or even outside that range.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
I'm new to access but in FileMaker Pro I would have done something like:

Basically if today's month is greater < or equal to 7 (ie July) then you
take today's year and add 1 and if not then take today's year. Then you take
away the DOB to get the number of years; And then at the end of it all you
subtract 4 as the normal school starting age.

This probably makes no sense!
 
Assuming you mean you subtract the year of birth, not the DOB, that sounds
like:

IIf(Month(Date)<=7, Year(Date) + 1, Year(Date)) - Year(DOB) - 4

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)
 
Thanks - you helped a great deal

My calculation ended up as:
=IIf(Month([Todays Date])>=7,Year([Todays Date])+1,Year([Todays
Date]))-IIf(Month([DOB])>=7,Year([DOB])+1,Year([DOB]))-4
 
Back
Top