I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative total of amount required for each group of part numbers sorted by earliest order date to lates order date of the part number. So for part number ABC I need the cumulative running total of amount required, for part number DEF I need the cumulative running total of amount required, etc. with each group of parts sorted by date the order was placed.
January 24, 2011 1:01 PM
July 12, 2011 4:02 PM