@birchard You might be able to accomplish this with the following:
UPDATE [Patron] SET [Age] = [Age] + 1 WHERE [Age] IS NOT NULL
Keep in mind that will increase the age of every person in the table - if you only want to do kids you'll have to improve the
WHERE clause to something like:
UPDATE [Patron] SET [Age] = [Age] + 1 WHERE [Age] IS NOT NULL AND [AGE] <= 18
It's a little more tricky for grades since apparently they are being stored as text and not numbers. Our data from last year does not have grades entered so I'm supplying this query without having tested it first - Take a database back up before you try it in case it doesn't work right!
UPDATE [Patron] SET [SchoolGrade] = [SchoolGrade] + 1 WHERE ISNUMERIC([SchoolGrade]) = 1
Since grade is stored alphanumerically it's possible there is non-numeric data in the field, this query won't help with that.
Of course, that math will put people into the next grade no matter what grade they entered. If you want to clear out the grade column for everyone over a certain grade you could use something like:
UPDATE [Patron] SET [SchoolGrade] = '' WHERE ISNUMERIC([SchoolGrade]) = 1 AND [SchoolGrade] > 12
Let me know how this works for you!