Writing an Expression in a Query to advance a student's grade 1 year on a specific date

[floridamom]

I'm developing a database for a non-profit group that works with kids. I have a query that is pulling the Student's names, ages, school name, and grade. I need to write an expression within the query that will advance the student's grade (for example from 6th grade to 7th grade) on August 1 of every year. Any suggestions?

[CJ_London]

A quick comment, It would be better to be storing the date of birth rather than age - otherwise every year you need to update that as well.

as for your question, from the information provided you need to use an update query and run it on 1st August

UPDATE myTable SET Grade= Grade+1