0

/t5/coldfusion-discussions/access-query-total/td-p/936725
May 07, 2008
May 07, 2008
Copy link to clipboard
Copied
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
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
TOPICS
Database access
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
1 Correct answer
LEGEND
,
May 08, 2008
May 08, 2008
ever tried this?
select numericfield1 + numericfield2 thesum
from etc
select numericfield1 + numericfield2 thesum
from etc
Mentor
,
/t5/coldfusion-discussions/access-query-total/m-p/936726#M85812
May 07, 2008
May 07, 2008
Copy link to clipboard
Copied
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
Phil
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

Guest
AUTHOR
/t5/coldfusion-discussions/access-query-total/m-p/936727#M85813
May 08, 2008
May 08, 2008
Copy link to clipboard
Copied
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!
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
/t5/coldfusion-discussions/access-query-total/m-p/936728#M85814
May 08, 2008
May 08, 2008
Copy link to clipboard
Copied
ever tried this?
select numericfield1 + numericfield2 thesum
from etc
select numericfield1 + numericfield2 thesum
from etc
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

Guest
AUTHOR
/t5/coldfusion-discussions/access-query-total/m-p/936729#M85815
May 08, 2008
May 08, 2008
Copy link to clipboard
Copied
OK! I used the sum function, and it is actually
working!
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

