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
MS-Access sum problem in query 2
Query changes on its own 2
append query results in footer 1
Limit query without using TOP 2
loop though records in a query? 5
"Overflow" message in UNION query 4

Top