Cumulative Values in a Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to add together the values in a column in a subform and
display them in another column in the same subform?
 
Pompeyjim,

One way to do this is via a Domain Aggregate Function. This can be done
in the query that the form is based on, or in the Control Source of the
textbox on the form. In the latter case, something like this...
=DSum("[TheAmount]","YourTable","[TheSortingField]<" & [TheSortingField])

If you have a very large number of records, the loading of the form may
be a little clunky.
 
Back
Top