Access Query - Total?

[Guest]

Hello~

I have query running in Access that works great, but I would like to add a field to the end of the results that sums up the total number of hours from each "week" table. Can anyone help? Thanks!

KC

[paross1]

Wow, what a horrid data model/structure. Why a different table for each week? What happens if you add a week21? Why not have a single week total table where there is an attribute (column) for week number so that you could select from a single table? It would sure make getting a total figure much easier.

Phil

[Guest]

I agree with you about the structure, but unfortunately this is an inherited application, and I do not have the resources at this time to rebuild it. There is never going to be a week21, which helps, but still... I would appreciate any advice on this Total problem! Thanks!

[Dan_Bracuk · Accepted solution]

ever tried this?

select numericfield1 + numericfield2 thesum
from etc

[Guest]

OK! I used the sum function, and it is actually working!