Adding a Total to a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that feeds a report that shows totals for labor and purchases
for each calendar year (i.e. 2002, 2003, 2004). Labor and Purchases
quantities make up "colums" and the calendar years (2002, 2003, 2004) make up
the rows. Is there any way to automatically add a 4th column that sums the
quantities for 2002, 2003, and 2004 under the labor and purchases columns
with out making a new query? Thanks for the help in advance!
 
You are describing a report something like this

Year Labor Purchases
=== ==== =======
2002
2003
2004

To add a column that gives you total labor and purchases, add a text box at
the end of the row. In the control source for that box put
= [Labor] + [Purchases]

If you want grand totals, do the same for a totals row following 2004
 
You have the Setup Right but what I want is the total for labor 2002, 2003,
and 2004 to be added together. I am not sure how to get this. Could you walk
me through it? (I think you knew what I was talkng about with the grand
totals but I don't know how to build this...). Thank you!

DevalilaJohn said:
You are describing a report something like this

Year Labor Purchases
=== ==== =======
2002
2003
2004

To add a column that gives you total labor and purchases, add a text box at
the end of the row. In the control source for that box put
= [Labor] + [Purchases]

If you want grand totals, do the same for a totals row following 2004
Jenn said:
I have a query that feeds a report that shows totals for labor and purchases
for each calendar year (i.e. 2002, 2003, 2004). Labor and Purchases
quantities make up "colums" and the calendar years (2002, 2003, 2004) make up
the rows. Is there any way to automatically add a 4th column that sums the
quantities for 2002, 2003, and 2004 under the labor and purchases columns
with out making a new query? Thanks for the help in advance!
Click to expand...
Click to expand...
 
Ok I found out how to do the totals but they appear like this:
Year Labor Purchases
=== ==== =======
2002 Total------
Total-----
2004
Click to expand...
Total----
and it becomes a running total.

I want it to look like this

Year Labor Purchases
=== ==== =======
2002
2003
2004
Click to expand...
Total----
And not be a running total but a grand total. Help!
Thanks!


Jenn said:
You have the Setup Right but what I want is the total for labor 2002, 2003,
and 2004 to be added together. I am not sure how to get this. Could you walk
me through it? (I think you knew what I was talkng about with the grand
totals but I don't know how to build this...). Thank you!

DevalilaJohn said:
You are describing a report something like this

Year Labor Purchases
=== ==== =======
2002
2003
2004

To add a column that gives you total labor and purchases, add a text box at
the end of the row. In the control source for that box put
= [Labor] + [Purchases]

If you want grand totals, do the same for a totals row following 2004
Jenn said:
I have a query that feeds a report that shows totals for labor and purchases
for each calendar year (i.e. 2002, 2003, 2004). Labor and Purchases
quantities make up "colums" and the calendar years (2002, 2003, 2004) make up
the rows. Is there any way to automatically add a 4th column that sums the
quantities for 2002, 2003, and 2004 under the labor and purchases columns
with out making a new query? Thanks for the help in advance!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top