Adding Sum
I made a query report with unique records to display,I don't want repeating
item displayed in the report.
What should I do to sum the other qty delivered in a single item.
Item Qty Date
Pork 50 08/01/05
60 08/10/05
20 08/15/05
should be
Item Qty Date
Pork 130 08/01/05 - 08/15/05
thanks & Godspeed.
|