Summarize Details

[Mercy]

Hello,

This should also be a VERY SIMPLE question...

My report runs on a qry ... and displays the data like so:
PO# Destination Qty Date
A1 JK 1 1/1/2003
A2 HK 2 1/8/2003
....

I want to also have a Sum of all the Qty values on the
bottom of the report. I tried putting this in the
detail section: Sum(Qty)

But that gives me the sum of Qty after each entry.
I tried grouping on Qty... and put Sum(Qty) in the Qty
footer... but it doesn't group the way I want it to.

Any input would be great!
Mercy

 

[Duane Hookom]

Place your sum() text box in the Report Footer (not Page Footer).