Adding a Total to a Report

[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!

 

[Guest]

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

 

[Guest]

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!

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

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!

 

[Guest]

Ok I found out how to do the totals but they appear like this:
Year Labor Purchases

=== ==== =======
2002 Total------
Total-----
2004

Total----
and it becomes a running total.

I want it to look like this

Year Labor Purchases

=== ==== =======
2002
2003
2004

Total----
And not be a running total but a grand total. Help!
Thanks!

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!

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

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!