Calculate average of multiple fields - new user
I am a new user and I am trying to recreate a function I had in Excel. I have people who have monthly totals (I input) then I need the 6 month average. Example Joe - 12/08, 1/09, 2/09, 3/09, 4/09, 5/09, 6 month average. Each person also appears in 2 other tables so I don't want to create a seperate table for each person. I only keep 6 months worth of monthly totals so it drops the oldest off every month. Is there any way to do this?
I need the 6 month average to appear as a field in another table. I wouldn't mind adding a field and deleting another every month but then I would have to move all the numbers or rewrite a script (I think).