Cumulative Totals in a Continuous Form

RayH

Registered User.
Local time
Today, 10:42
Joined
Jun 24, 2003
Messages
132
I am trying to create a DB that was Originally an Excel Spreadsheet.
The Spreadsheet performs a Cumulative calculation based on values from the cell above.

e.g
Row 2 =(SUM($E$2:E2))/(SUM($D$2:D2))
Row 3 =(SUM($E$2:E3))/(SUM($D$2:D3))
Row 4 =(SUM($E$2:E4))/(SUM($D$2:D4))
The cell is formatted as a Percentage.

To emulate this I have created a Continuous Form. However, I am struggling to populate a

textbox with the correct figure.
How can I SUM both sides of the sum correctly to get the right answer?

Ultimately, the calculation will be restricted by date range, ie. Last 12 months worth of

data.
Where should I start? Build a query to get the figures? Use a sum in the Control Source of

the field?

As a test I put =Sum([MyValue]) in the Control Source of a text box called [MyTotal] but

the result was that ALL of the [MyTotal] fields on the form had the same value.
This may or may not be related but I include it to give some insight into the possiblilty

that Access simply cannot do what I want. I hope that I'm wrong!

Thanks
 

Users who are viewing this thread

Back
Top Bottom