How to chart a Dsum calculations

[Guest]

I am trying to chart (preferably Pivot Chart) a DSum query showing the
cumulative sum by sample date. The SQL for my query is as follows:

SELECT qrySKEmergenceStats.DATE_SAMPLED, qrySKEmergenceStats.SumOfSKPERHR,
DSum("[qrySKEmergenceStats].[SumOfSKPERHR]","qrySKEmergenceStats","[date_sampled] <= #" & qrySKEmergenceStats.date_sampled & "#") AS CUMSUM_SKPERHR
FROM qrySKEmergenceStats;

The chart results in a count of the records and not the cumulative sum result.
Thanks for your help!!!!!

 

[[MVP] S.Clark]

Maybe post the SQL for qrySKEmergenceStats to give us a better idear.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Guest]

Sure:
qrySKEmergenceStats is:
SELECT qrySKEmergence.DATE_SAMPLED, Sum(qrySKEmergence.SKPERHR) AS
SumOfSKPERHR
FROM qrySKEmergence
GROUP BY qrySKEmergence.DATE_SAMPLED;

and qrySKEmergence is:
SELECT tblSKEmergence1.SKEMERGEID, tblSKEmergence1.DATE_SAMPLED,
tblSKEmergence1.NO_SK, tblSKEmergence1.START_TIME, tblSKEmergence1.END_TIME,
DateDiff("n",[START_TIME],[END_TIME]) AS SOAKMIN, [SOAKMIN]/60 AS SOAKHR,
[NO_SK]/[SOAKHR] AS SKPERHR
FROM tblSKEmergence1;

Thanks for your help!!

Maybe post the SQL for qrySKEmergenceStats to give us a better idear.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

I am trying to chart (preferably Pivot Chart) a DSum query showing the
cumulative sum by sample date. The SQL for my query is as follows:

SELECT qrySKEmergenceStats.DATE_SAMPLED, qrySKEmergenceStats.SumOfSKPERHR,
DSum("[qrySKEmergenceStats].[SumOfSKPERHR]","qrySKEmergenceStats","[date_sampled]
<= #" & qrySKEmergenceStats.date_sampled & "#") AS CUMSUM_SKPERHR
FROM qrySKEmergenceStats;

The chart results in a count of the records and not the cumulative sum
result.
Thanks for your help!!!!!

 

[Guest]

Any suggestions out there??? I am so close to making this work, but can't
figure it out. I can only get the "count" of the number of records to chart
and not the calculated cumulative sum. THANKS!!!!!

Sure:
qrySKEmergenceStats is:
SELECT qrySKEmergence.DATE_SAMPLED, Sum(qrySKEmergence.SKPERHR) AS
SumOfSKPERHR
FROM qrySKEmergence
GROUP BY qrySKEmergence.DATE_SAMPLED;

and qrySKEmergence is:
SELECT tblSKEmergence1.SKEMERGEID, tblSKEmergence1.DATE_SAMPLED,
tblSKEmergence1.NO_SK, tblSKEmergence1.START_TIME, tblSKEmergence1.END_TIME,
DateDiff("n",[START_TIME],[END_TIME]) AS SOAKMIN, [SOAKMIN]/60 AS SOAKHR,
[NO_SK]/[SOAKHR] AS SKPERHR
FROM tblSKEmergence1;

Thanks for your help!!

Maybe post the SQL for qrySKEmergenceStats to give us a better idear.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

I am trying to chart (preferably Pivot Chart) a DSum query showing the
cumulative sum by sample date. The SQL for my query is as follows:

SELECT qrySKEmergenceStats.DATE_SAMPLED, qrySKEmergenceStats.SumOfSKPERHR,
DSum("[qrySKEmergenceStats].[SumOfSKPERHR]","qrySKEmergenceStats","[date_sampled]
<= #" & qrySKEmergenceStats.date_sampled & "#") AS CUMSUM_SKPERHR
FROM qrySKEmergenceStats;

The chart results in a count of the records and not the cumulative sum
result.
Thanks for your help!!!!!