Running Total

[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

 

[Noëlla Gabriël]

Hi,

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