Running Sum in query

[alecgreen]

Hi

I am trying to create a running total on a number field, dependant on
the criteria in my query. I have tried this on a report which adds up
the sum as it goes down the report, can this be replicated in a query?

Many Thanks


Alec

 

[Bob Barrows]

Hi

I am trying to create a running total on a number field, dependant on
the criteria in my query. I have tried this on a report which adds up
the sum as it goes down the report, can this be replicated in a query?

Maybe. It depends on the details which you have not provided (a few rows of
sample data in tabular format followed by desired results also in tabular
format never hurts). The idea would be to use a correlated subquery if your
data is structured in such a way to support it.