Cumulative Values in a Subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pompeyjim - 15 Jul 2005 09:09 GMT

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

Reply to this Message

Steve Schapel - 15 Jul 2005 19:49 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

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

Reply to this Message