Hi everyone, This is my first post at vbforums so I hope I am doing so properly. I a high school teacher and am constructing a simple database to house my students scores assignment scores and have run into a small problem. As the grading period progresses I manually add more fields to the "t_assignments" table and then modify a query that calculates the average of all the fields in the record. An example of the table is here

http://mrgriggs.com/help/assignments.pdf

The assignment for tomorrow will be called W4_A2 and will be added manually to the table. Then I will manually modify the query that pulls the information from the table so that the new field is included in the average. I basically add up the assignments and divide by the number of assignments. So if there were 3 assignments my code would be ...(A1 + A2 + A3)/3....after I add the new assignment I change it to (A1 + A2 + A3 + A4)/4. My question is how can a work around having to manually adjust the query that calculates the average?

Thanks