How would I build a query to get cumulative totals on a form?

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

Guest

Hello! .... I'm in way over my head on this one but here's my problem:
basically, I've been asked to show (on a form or subform) results on a
Monthly, Quarterly and Year-to-Date basis. The table structure I currently
have is as follows (additional fields and/or tables can be added if it would
help get the results desired):

ID Date Volume/Value
A1 Jun-05 10,000
A2 May-05 15,000
A3 Apr-05 12,000
A4 ------ ------
An May-04 11,000
B1 Jun-05 10,000
B2 May-05 15,000
B3 Apr-05 12,000
B4 ------ ------
Bn May-04 11,000

Part of the trick with this is to be able to show these aggregate values
(quarterly, YTD, and on a 13-month rolling basis) as users enter new data for
whatever the current month is. Any assistance in helping me get this
accomplished would be enourmeously appreciated. Thanks
 
With your form (or subform) set up in continuous forms mode, you can add a
text box to the form footer. The datasource of the textbox in the form
footer would be:

=Sum([TheNameOfTheFieldYouWantToSum])

Linda
 
Back
Top