Please help...how a field automatically update every year....?

[Anna]

I am working on a grade school database. I would like to set a field for each
grade. How can the field automatically update evey year? For example, a
student is in G1, the field will update to G2 in Sept. Please help....

 

[Ralph]

Talk about "No child left behind". You are assuming every child will be
promoted to the next grade? Microsoft has a Access classroom template that is
excellent.

http://office.microsoft.com/en-us/templates/TC010184071033.aspx?CategoryID=CT101426031033