Thread: Adding Sum
View Single Post
  #1   Report Post  
nono
 
Posts: n/a
Default 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.