Cumulative Totaling

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a column of numbers by sale date and I would like
to create an additional column that is a cumulative total
by sale date of my original column of numbers. What is
the best approach to do this in a query? Thanks.
 
In your query use this expression instead of the name of the Sale Date
field:
SaleDateField:NameOfSaleDateField
Sort the query by SaleDateField ascending. In a blank field of the query
put:
CumulativeTotal:DSum("[NameOfNumbersField]","NameOfTableContainingNumbersAnd
SaleDate",
"[NameOfSaleDateField] < [SaleDateField]")
 
Back
Top