Query Question

[Guest]

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

Anyway, each year, I need to increment the the student grade column for each
student record (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 would like to automate this process. Can I use
an updating query and of so how? Any suggestions

 

[Randy Harris]

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

Anyway, each year, I need to increment the the student grade column for each
student record (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 would like to automate this process. Can I use
an updating query and of so how? Any suggestions

This can certainly be done with a query, but the method (and complexity) is
dependant upon whether the grade is stored as a number or text. I would
guess the latter, since your example showed 1st to 2nd, etc. If that is the
case, are you certain that all the records use the identical text - ALL 1st
graders are "1st", never "first" or "1" and so on?

 

[Larry Daugherty]

Use an Update Query. Make grade = grade+1

HTH

 

[Guest]

Seems like you would want a new record for the new school year that has
school year as a date field. In this case use an append query - Grade+1 -
and added field School Year: "2005-2006" as a new column.