how to I make a sum of a column on a report

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

Guest

I have a report made that displays order information by customer. I have
created a sum column on the far right that gives the extended price per
product (quantity*price). I have been trying to then sum up that column to
display a total at the bottom of the page, giving a sum of all the individual
sums. Does anyone know the formula for doing something like that? Thanks
for your help!
Nikki
 
Yes, I have a field (quantity*price) already, what I want to do is sum up all
the values in that (quantity*price) field in the report footer for a total.
Any idea how to do that?
thanks-Nikki
 
In the report's detail section, add an unbound text control and set its
properties:
Name: txtExtPrice
Visible = False
Control Source: =[YourQty*PriceControl]
Running Sum: "Over All"

Then in an unbound text control in the footer, set its control source:
=[txtExtPrice]

HTH,
Brian

then in the footer, you canr
 
nikki said:
Yes, I have a field (quantity*price) already, what I want to do is
sum up all the values in that (quantity*price) field in the report
footer for a total. Any idea how to do that?
thanks-Nikki
Click to expand...

create a hidden control in the body of the report [quanity]*[price] and
then in the footer a control

=sum(NameOfHiddenControl)
 
I have a report made that displays order information by customer. I have
created a sum column on the far right that gives the extended price per
product (quantity*price). I have been trying to then sum up that column to
display a total at the bottom of the page, giving a sum of all the individual
sums. Does anyone know the formula for doing something like that? Thanks
for your help!
Nikki
Click to expand...

It's better in this case to calculate the extended price as a
calculated field in the Query upon which the form is based.

You can't (easily) do the sum in a Page Footer but you can make the
Report Footer visible; or if you want a sum for each customer, use the
Report's Sorting and Grouping dialog to group by customer, and make
the Section footer visible. On either the section footer or the form
footer (or both, if you want a grand total) you can put a textbox

=Sum([ExtPrice])

in the footer area.

John W. Vinson[MVP]
 
Back
Top