Recent content by colincliff

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)))

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

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...