excel file solved in access

[miltos]

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.

[ajetrumpet]

yes it is, through recordset usage only.

[miltos]

yes it is, through recordset usage only.

Any ideas how?

Thank you

[ajetrumpet]

well, open the recordset in vba and loop it, summing the last 6 rows to a variable. and if I'm now reading the OP correctly, you can import that data and run a query on it by summing each column and using the TOP predicate as well as a DESC order by clause. like so:

select top 6 dsum(this), dsum(that), etc...

from table

order by myfield DESC

[johnlinkson]

It is easy way to complete it.