Running Total

  • Thread starter Thread starter rob muzzy
  • Start date Start date
R

rob muzzy

Hi,
I have a query with the following code:
SELECT Query2.PART_ID, Query2.PRODUCT_CODE, Query2.ORDER_QTY, ROUND
(([QUERY2].[ORDER_QTY]/[QUERY2].[TOTAL])*100,2) AS [SUM]
FROM Query2
WHERE (((Query2.PRODUCT_CODE) Like 'LINERS'))
ORDER BY ROUND(([QUERY2].[ORDER_QTY]/[QUERY2].[TOTAL])*100,2) DESC;

I am trying to get a running total of the [Sum] field for an 80/20
report where i add the value of Sum.Record1 to sum.record2 in a new
column called and show it where record sum of record2 is and so on in
a column called [Percent Volume]




Rob
 
Hi,

you could try a dsum function where you add up all values with a round value
lesser or equel to the current value.
 
Back
Top