Hi.
I work in education and I'm currently creating a database for all our SEN pupils. Because their year group will increase by 1 each September I use 'Start Date' and work out the year group from that. That way it will increment automatically each year.
Problem is, it won't update till...