Running Total Query

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 create a running total to take the sum and show the
running count of sum. Meaning i want to take the value of sum.row2 and
add it to sum row1 and show the sum of row1+row2 and so on keeping a
running total. This is for an 80/20 report. can anyone help me with
some code?


Rob
 
?

???

rob muzzy said:
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 create a running total to take the sum and show the
running count of sum. Meaning i want to take the value of sum.row2 and
add it to sum row1 and show the sum of row1+row2 and so on keeping a
running total. This is for an 80/20 report. can anyone help me with
some code?


Rob
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Total 1
Crosstab query totals 3
append query results in footer 1
Query is Crashing Access 2003 sp3 4
How to daisy chain queries and use the output from one query as parameter for another 1
Totals Query 10
Create a running total for last twelve months 0
calculated total in query 2

Top