Rolling Sum In A Query

[Craig0201]

Hiya everyone.....

Happy holidays.....

I need to create a query with a rolling sum calculated in it based upon a particular field. Very easy in a spreadsheet but how do I convert it to Access query stuff?

All help appreciated as always!!



Craig

 

[DougP]

When you say rolling sum. What exactly are you referring too.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[skfoster]

Is it running sum? If yes, add new field RunTot and write syntax something like: SELECT Orders.EmployeeID AS EmpAlias, Sum(Orders.Freight) AS SumOfFreight, Format(DSum(&quot;Freight&quot;,&quot;Orders&quot;,&quot;[EmployeeID]<=&quot; &amp; [EmpAlias] &amp; &quot;&quot,&quot;$0,000.00&quot AS RunTot
FROM Orders
GROUP BY Orders.EmployeeID;