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
2))
Row 3 =(SUM($E$2:E3))/(SUM($D$2
3))
Row 4 =(SUM($E$2:E4))/(SUM($D$2
4))
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
The Spreadsheet performs a Cumulative calculation based on values from the cell above.
e.g
Row 2 =(SUM($E$2:E2))/(SUM($D$2

Row 3 =(SUM($E$2:E3))/(SUM($D$2

Row 4 =(SUM($E$2:E4))/(SUM($D$2

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