M
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
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