S
ScottR3
This is my first attempt at using dsum() in a query and I almost have it,
however, the running total is running in the wrong direction.
SELECT CustomerYTDSales.CUID, CustomerYTDSales.YTDSales,
DSum([YTDSales],"CustomerYTDSales") AS Expr1
FROM CustomerYTDSales
ORDER BY CustomerYTDSales.YTDSales DESC;
I have sorted YTDSales in descending order with the highest sales at the top
of the list. Dsum() in the above query is running from the bottom (lowest
sales) to the top. How can I reverse dsum to work from the top down?
By the way, I changed YTDSales to ASCENDING just to see if that would affect
how Dsum() worked. Dsum didn't change. It still totaled from the smallest
sales to the largest.
Scott
however, the running total is running in the wrong direction.
SELECT CustomerYTDSales.CUID, CustomerYTDSales.YTDSales,
DSum([YTDSales],"CustomerYTDSales") AS Expr1
FROM CustomerYTDSales
ORDER BY CustomerYTDSales.YTDSales DESC;
I have sorted YTDSales in descending order with the highest sales at the top
of the list. Dsum() in the above query is running from the bottom (lowest
sales) to the top. How can I reverse dsum to work from the top down?
By the way, I changed YTDSales to ASCENDING just to see if that would affect
how Dsum() worked. Dsum didn't change. It still totaled from the smallest
sales to the largest.
Scott