How can a specific field automatically change every year?

[Anna]

I'm working on an elementary database. There is a specific field for grader.
For example, there is a student who is first grader so I put G1. He will
become the second grader in Sept. I would like the field automatically change
to G2 in Sept. We have a thousand students. It's hard to change it manually.
I'm talking about something like age. The age field will change every year.

 

[fredg]

I'm working on an elementary database. There is a specific field for grader.
For example, there is a student who is first grader so I put G1. He will
become the second grader in Sept. I would like the field automatically change
to G2 in Sept. We have a thousand students. It's hard to change it manually.
I'm talking about something like age. The age field will change every year.

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.