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

[Spartacus]

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

 

[Linda Burnside]

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