Update Query Question

[Guest]

I have a databae which houses student information (grade address etc.)

ANyhow, you all have been so helpful in this my first database creation...
I am sure someone may have an answer to this question... Hopefully I can
learn as much and pass it along to others when I get up to speed )

Anyway, each year, I need to increment the the student grade (example, 1st
to 2nd, 2nd to 3rd and so forth). There are 500 records in this database and
up til now the secretary has been hand changing these records one by one. I
woul like to automate this process. Any suggestions

 

[Guest]

It'd be better to track them by their graduation year, but if you don't mind
the annual tweaking:

docmd.runsql "UPDATE tablename SET tablecolumn=value WHERE condition=true"

or,

docmd.runsql "UPDATE students SET grade=2 WHERE grade=1"

hth,

Nick