Auto Update Field

[Guest]

I have a form (Master Form) based upon a underlying table which holds all the
core data for pupils. I would like to be able to auto fill the school year
group (NCY) from the Date of Birth (DOB) field.

I know it is possible to do something similar from date of birth to age, but
I have been stuck on how to apply this to year group.

Any help or suggestions would be very gratefully received

 

[Al Camp]

bamf,
What are you try to calculate?
What is the School Year Group, and how do you determine that?
Please provide more details...

 

[Douglas J Steele]

You shouldn't be storing NCY in the table. Instead, you should be adding the
calculation as a computed field in a query, and use the query wherever you
would otherwise have used the table.

Without knowing the calculating for NCY, though, I'm afraid I can't give you
the exact formula to use.

 

[Guest]

Thank you for your responses.

The NCY is calculated from date of birth. For example if the date of birth
is between #01/09/1999# and #31/08/2000# then the NCY should be 1 and NCY
ranges from -3 to 15

 

[Douglas J Steele]

What's the actual calculation? I'm guessing it's based on their age as of
September 1st.

 

[Guest]

It is usually calculated by which time period their date of birth falls into.
However, it could also be calculated by their age as of the 31st August

sorry if I have been unclear, am still slightly new at this!