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]")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative counts in a query 2
Calculating percentage growth rate from a cumulative figure 4
Apparent glitch with DSum in Query - begins with October, 2005 7
How to build a query for cumulative total 1
Access YTD - Form 0
counting functions 3
Update from two tables 1
Cumulative total in a query 1

Back
Top