Auto Update Field

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

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
 
bamf,
What are you try to calculate?
What is the School Year Group, and how do you determine that?
Please provide more details...
 
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.
 
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
 
What's the actual calculation? I'm guessing it's based on their age as of
September 1st.
 
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!
 
Back
Top