If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
DSum not summing correctly
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. |
#3
|
|||
|
|||
DSum not summing correctly
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. |
#4
|
|||
|
|||
DSum not summing correctly
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DSum function | Robert | Worksheet Functions | 3 | November 17th, 2004 02:47 PM |
DSUM search issues | needyourhelp | General Discussion | 1 | July 2nd, 2004 09:17 PM |
DSUM Criteria and Excel Help | Earl Kiosterud | Worksheet Functions | 2 | April 30th, 2004 07:55 PM |
DSUM or SUMPRODUCT wont work. | Nimit Mehta | Worksheet Functions | 1 | April 27th, 2004 01:39 PM |
Alternative to calc differences of DSUM functions (with 5 or 6 criteria) | Dave | Worksheet Functions | 3 | March 29th, 2004 08:01 PM |