I want to update one field in my table. What i have is a player information table which has basic information on each player. The one i am concerned with is the grade field. What i'm trying to do is at the end of the year run a query to update each athletes grade to next grade.
For example grade 11 to 12, grade 10 to 11 etc.
The fiels name is called Grade.
How do i set up my query to add one to each grade
Greg
For example grade 11 to 12, grade 10 to 11 etc.
The fiels name is called Grade.
How do i set up my query to add one to each grade
Greg