Running Sum in query

  • Thread starter Thread starter alecgreen
  • Start date Start date
A

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
 
alecgreen said:
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?
Click to expand...
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.
 
Back
Top