Search results

  1. C

    expression to calculate childs school year in an access form

    i think i have worked out a way to do this incase anyone else needs it. the following expression seems to work for me: =(Year(Date())-iif(Month([hck_dob])>8,Year([hck_dob])+6,(Year([hck_dob])+5)))
  2. C

    calculate students current grade based on Birthday

    Hi ralphyehle, i'm looking for the answer to this too! What expression did you use in the end? thanks in advance :)
  3. C

    expression to calculate childs school year in an access form

    Hi. I'm not an access expert by any means, but i have some experiance at building basic databases. I am trying to make a basic pupil registration/attendance database in the U.K. I need an expression that will calculate a childs school year (grade) based on their date of birth. In England, the...
Top Bottom