Total SUM of SumOf in Access query

[EMax1]

My query is as follows:


SELECT ALLVAN.VENDNB, Sum(ALLVAN.SALYTD) AS SumOfSALYTD, Sum(ALLVAN.SALLYTD) AS SumOfSALLYTD, ALLVAN.PRDNB
FROM ALLVAN
GROUP BY ALLVAN.VENDNB, ALLVAN.PRDNB
ORDER BY ALLVAN.VENDNB, Sum(ALLVAN.SALYTD) DESC;

this is fine, but I would like to be able to calculate the sum of the SumofSALLYTD to have the total of all the SumOfAllytd generated by this query.
Is-it possible or do I need to do it with an external program?

Help would be appreciated on that oine.
Thanks in advance

 

[lespaul]

Create a new query and use this query as the source (if you are using the query design grid, when you first create the query you can choose tables or queries as the source).

HTH

Leslie

 

[EMax1]

Actually What I am looking is a query that could generate something like thgis

VendNB SumOfSALLYTD TotalAllSum
111 1 1
222 3 4
333 2 6

the field TotalAllSum beeing calculated at each row

 

[lespaul]

you mean you want a cumulative total. Search around this forum and the other access forums, there are several threads on cumulative totals.

HTH

leslie


Leslie

 

[EMax1]

thanks
louis