How to make a running sum in Query ?

R

rock72

Hello Everyone,

Can anyone tell me how to create a running sum in query ? Days should
be from 1st record 1, then 2nd record 2 and so on......

Thanks

Tim
 
S

Salad

rock72 said:
Hello Everyone,

Can anyone tell me how to create a running sum in query ? Days should
be from 1st record 1, then 2nd record 2 and so on......

Thanks

Tim
Click to expand...
You can do something like
Select ID, DCount("ID","Table","ID <= " & [ID]) _
From Table Order By ID

A query like this will be slower due to overhead.
 
Top