O
Opal
I am trying to create a query that will show a running
sum of a calculated field as this query builds a chart.
Here is my SQL prior to adding a DSum expression:
SELECT Left([Activity],12) AS ActivityName,
[CostSavingsperYear]/250000 AS CostReduction,
10.37 AS Target
FROM Activity
GROUP BY Left([Activity],12),
[CostSavingsperYear]/250000, 10.37
ORDER BY [CostSavingsperYear]/250000;
(The Activity field in the Table is a memo field so I
am only collecting the first 12 characters as the
value on the X-axis for the chart.)
I want to create a running sum of the
Cost Reduction field, but am stuck on the
DSum expression. I tried:
RunTotalSum("CostReduction","qryCostReduction",
"[Activity]<=" & [ActivityName] & "")
No doubt I cannot use the DSum against fields in the query.
So how do I achieve the desired results? Dies anyone
have any advice?
sum of a calculated field as this query builds a chart.
Here is my SQL prior to adding a DSum expression:
SELECT Left([Activity],12) AS ActivityName,
[CostSavingsperYear]/250000 AS CostReduction,
10.37 AS Target
FROM Activity
GROUP BY Left([Activity],12),
[CostSavingsperYear]/250000, 10.37
ORDER BY [CostSavingsperYear]/250000;
(The Activity field in the Table is a memo field so I
am only collecting the first 12 characters as the
value on the X-axis for the chart.)
I want to create a running sum of the
Cost Reduction field, but am stuck on the
DSum expression. I tried:
RunTotalSum("CostReduction","qryCostReduction",
"[Activity]<=" & [ActivityName] & "")
No doubt I cannot use the DSum against fields in the query.
So how do I achieve the desired results? Dies anyone
have any advice?