I enter pupils weekly test marks into a database. Using various parameters set by the user I am able to extract any group of marks for any pupil in any subject between any set of dates and print a report which has at the bottom the average of any group of marks.
What I would like is a query which will give me the running average of a pupil since every week the averge is changing. I want to be able to see week 1 -avg was 78, week 2 avg was 81 , week 3 avg was 77 etc. (I would then use prevrecval function to calculate whether it has gone up or down and display accordingly alongside. What sort of a query am I looking for? Is this a crosstab ? or more complex?
Thanks

Solved it myself1
Made 2 invisible controls ,one a running sumof every weeks mark, the other =1 in controlsource and also running sum to give me the number of tests taken. then simply divide the first by the second to give me the running average!