Lots of totals in one?

[Wazz]

Hi Guys,
i have 6 tables in a database. The tables just hold totals (manually entered by the user). What I would like to do is have the results from each table, added up and put into one report.
in a bit more depth.. that database just deals with stats..
Team1 (table 1)
a =5
b=6
c=7
Team 2 (tables 2)
aa =3
bb=10

etc... and there are 6 teams.
these stats are entered daily.

Next.. The stats are usually pulled of weekly.. So my query starts by using date ranges (i have done this). It does appear though that there are too many 'sum' calculations to be done to get all of the above stats info on to one report.

Is there a way round this?

Any help would be great

Cheers

Wazz

 

[Wazz]

anyone??

pretty please

 

[PaulBricker]

Well maybe you could expand a little on this. For example you show Table1 with values 5,6 and 7. When you say you want the "results from each table added up" does that mean that for Table1 the value would be 18 and for Table2 it would be 13? And then all six tables shown in the Report.

Also, I'm unclear what you mean when you say "It does appear though that there are too many 'sum' calculations to be done to get all of the above stats info on to one report".

Maybe adding some additional info will help.

Paul