Help Please_ Cummulative Sum

Sep 25, 2007

In an access tble is there a way to do a cummulative sum, in excel it easy, but I have over 100K records and need to decile a database???

View Replies

Calculating Cummulative Distance

Jun 22, 2007

I am trying to create a query that gives me a cummulative distance based on a previous footages. For example I am prompting the user to enter a Route. Along the route are several points having a numeric value. Each of these points along the route have a footage accociated to the previous point. I want the query to display the Route, each point along the route based on the users defined start and end point, show each backspan footage and provide a cummulative distance based on the progression of the route. Below is what I have created so far. Now I want to add a cummulative distance.

SELECT PED.ROUTE_1, PED.TERMINAL_1, PED.TERMINAL_1, Sum(PED.BACKSPAN_1) AS SumOfBACKSPAN_1
FROM PED
GROUP BY PED.ROUTE_1, PED.TERMINAL_1, PED.TERMINAL_1
HAVING (((PED.ROUTE_1)=[ enter route ]) AND ((PED.TERMINAL_1)>[enter start]) AND ((PED.TERMINAL_1)<[enter end]));

Thanks for any help.

View 2 Replies View Related