Putting a sum in a report. 2

[KraigC]

Ok, I am trying to add a sum to a series of totals, I placed the unbound box in the footer but it puts a total under each record entry. I am about to pull my hair out HELP PLEASE!!!
Example
PartName, Partnumber, Qtyordered, Qty Shipped
4000 4000
4000 4000
(total)

 

[THWatson]

KraigC
From your explanation, it sounds to me as if you have the unbound text box either in the Detail Section or a Group Footer, whereas it needs to go in the Report Footer.

Tom

 

[KraigC]

Thanks, I placed it in the footer but it still gives me a 0 total now at the bottom of the page. I have items sorted in the report page this is what it looks like

PartName, Partnumber, Qtyordered, Qty Shipped
4000 4000
4000 4000
(total)
PartName, Partnumber, Qtyordered, Qty Shipped
4000 4000
4000 4000
(total)
Thanks for the help this is the formula that I have in the unbound box =Sum([QTYSHIPPED])

 

[Remou]

This post is a continuation of:
Putting a sum under a series of totals
thread702-1200052

 

[KraigC]

I placed the Total box in the QTY Ordered footer and when I run the report it shows up exactly where I need it to but there is still 0 in the totals box.

 

[Remou]

Have you tried creating a report using the wizard? It can be quite helpful. If you choose a field to group by, you will be given a chance to add Summary Options.

 

[KraigC]

I will work on this today at work and will go that route will let you know what I come up with. Thanks for the help

 

[KraigC]

I got it, Thanks to all the great help. I think I was making it more complicated then it should. Kraig