Having trouble with creating a Column total at the bottom of a rep

[K Yero]

I am using Access 2003. I have a 5-6 page report that generates off a query
that I wrote where all the information for a record prints on a horizontal
format (included below). I have colums of data to the left and right of these
columns. I have figured out how to put in the text boxes, labels and control
source statement to make my Ext Revenue calculate correctly in my report, but
now I have a different issue that I can't figure out. I would like to create
a label and text box in either the footer or better yet once at the bottom of
the report that totals my Extended Revenue column. I know it should be able
to be done, but am not grasping how to do it.
Can anyone help with this? I have Access for Dummies and I guess, well you
know....:-(

Probability Qty Revenue Ext Revenue
25% 2 $500,000.00 $250,000.00

 

[Marshall Barton]

I am using Access 2003. I have a 5-6 page report that generates off a query
that I wrote where all the information for a record prints on a horizontal
format (included below). I have colums of data to the left and right of these
columns. I have figured out how to put in the text boxes, labels and control
source statement to make my Ext Revenue calculate correctly in my report, but
now I have a different issue that I can't figure out. I would like to create
a label and text box in either the footer or better yet once at the bottom of
the report that totals my Extended Revenue column. I know it should be able
to be done, but am not grasping how to do it.
Can anyone help with this? I have Access for Dummies and I guess, well you
know....:-(

Probability Qty Revenue Ext Revenue
25% 2 $500,000.00 $250,000.00

You can total the Ext Revenue in the group footer and/or the
report footer by using a text box with and expression like:
=Sum(<same expression as Ext Revenue text box>)

If you can't make that work, post back with more details
about how the value is calculated.