my excel file is like that:
Division, Date, HomeTeam, AwayTeam, STGH, STGA, SOTH, SOTA
E0, 23/12/10, Arsenal, Everton, 3, 0, 10, 5
E0, 28/12/10, Chelsea, Wolves, 4, 1, 15, 3
etc
I want for each HomeTeam and for each AwayTeam to sum up the last 6 and the last 3 rows of the cols ''STGH'', ''STGA'', ''SOTH'' and ''SOTA''.
Is it possible with access?
Thank you.