Skip to main content
A
Anonymous
May 7, 2008
Answered

Access Query - Total?

  • May 7, 2008
  • 3 replies
  • 622 views
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
This topic has been closed for replies.
Correct answer Dan_Bracuk
ever tried this?

select numericfield1 + numericfield2 thesum
from etc

3 replies

D
Dan_BracukCorrect answer
Inspiring
May 8, 2008
ever tried this?

select numericfield1 + numericfield2 thesum
from etc
A
Anonymous
May 8, 2008
OK! I used the sum function, and it is actually working!
A
Anonymous
May 8, 2008
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!
P
paross1
Participating Frequently
May 7, 2008
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices