DSum not summing correctly

=DSum("LowTestEstimate + LowProgramEstimate + LowSAEstimate","Est Hours","Platform='Dispatch' And PlanReleaseVer=Forms![Est Hours]![PlanReleaseVer]")

first set of three variables are columns in the table create by the query "est hours"

I have this in the report footer and it appears to work correctly, but only for the information displayed on the same page as the footer? What do I need to do to get this to sum over the entire report? I have tried to move it to different sections of the report, like the page footer and the details section, but I have not gotten the sum of these values over the whole report. Any help would be appreciated.

I don't think there is any reason to use DSum(). If you want to sum the
values of these fields in your report records, then use:

=Sum(Nz(LowTestEstimate,0) + Nz(LowProgramEstimate,0) + Nz(LowSAEstimate,0))

--
Duane Hookom
MS Access MVP
--

"AndyS" wrote in message
...
=DSum("LowTestEstimate + LowProgramEstimate + LowSAEstimate","Est
Hours","Platform='Dispatch' And PlanReleaseVer=Forms![Est
Hours]![PlanReleaseVer]")

first set of three variables are columns in the table create by the query
"est hours"

I have this in the report footer and it appears to work correctly, but
only for the information displayed on the same page as the footer? What do
I need to do to get this to sum over the entire report? I have tried to
move it to different sections of the report, like the page footer and the
details section, but I have not gotten the sum of these values over the
whole report. Any help would be appreciated.

Notice the conditional in the Dsum, that is wht I was using it. If there is a way to do this with just the sum then fine. But dsum seems to work, just for the data that is printed on the same page as the report footer, why is this, and what can i do to get it to include all the report data? Besides I though dsum was independent of the report data and used the query that I specified to lookup its' information?

"Duane Hookom" wrote:

I don't think there is any reason to use DSum(). If you want to sum the
values of these fields in your report records, then use:

=Sum(Nz(LowTestEstimate,0) + Nz(LowProgramEstimate,0) + Nz(LowSAEstimate,0))

--
Duane Hookom
MS Access MVP
--

"AndyS" wrote in message
...
=DSum("LowTestEstimate + LowProgramEstimate + LowSAEstimate","Est
Hours","Platform='Dispatch' And PlanReleaseVer=Forms![Est
Hours]![PlanReleaseVer]")

first set of three variables are columns in the table create by the query
"est hours"

I have this in the report footer and it appears to work correctly, but
only for the information displayed on the same page as the footer? What do
I need to do to get this to sum over the entire report? I have tried to
move it to different sections of the report, like the page footer and the
details section, but I have not gotten the sum of these values over the
whole report. Any help would be appreciated.

You can add conditions to the expression like:
=Sum( Nz(LowTestEstimate,0) + Nz(LowProgramEstimate,0) + Nz(LowSAEstimate,0)
* Abs( Platform="Dispatch" And
PlanReleaseVer=Forms![EstHours]![PlanReleaseVer] ) )

This should calculate based on only your report results and not necessarily
the entire query or table. It is much more efficient compared with DSum().

--
Duane Hookom
MS Access MVP
--

"AndyS" wrote in message
...
Notice the conditional in the Dsum, that is wht I was using it. If there
is a way to do this with just the sum then fine. But dsum seems to work,
just for the data that is printed on the same page as the report footer, why
is this, and what can i do to get it to include all the report data?
Besides I though dsum was independent of the report data and used the query
that I specified to lookup its' information?

"Duane Hookom" wrote:

I don't think there is any reason to use DSum(). If you want to sum the
values of these fields in your report records, then use:

=Sum(Nz(LowTestEstimate,0) + Nz(LowProgramEstimate,0) +
Nz(LowSAEstimate,0))

--
Duane Hookom
MS Access MVP
--

"AndyS" wrote in message
...
=DSum("LowTestEstimate + LowProgramEstimate + LowSAEstimate","Est
Hours","Platform='Dispatch' And PlanReleaseVer=Forms![Est
Hours]![PlanReleaseVer]")

first set of three variables are columns in the table create by the
query
"est hours"

I have this in the report footer and it appears to work correctly, but
only for the information displayed on the same page as the footer? What
do
I need to do to get this to sum over the entire report? I have tried to
move it to different sections of the report, like the page footer and
the
details section, but I have not gotten the sum of these values over the
whole report. Any help would be appreciated.