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
|
|||
|
|||
Sum DCOUNT Calculated Control
Hi Folks - I am using DCOUNT like this:
=DCount("disp1","qrycombinedispositions","disp=qry combinedispositions.disp1") I am counting the number of different dispositions based on a control in the report. It works fine. I'd like to sum the individual counts into a grand total. I realize you cannot sum a calculated control. I've tried the workaround of using another text box control that sets the control source to the calculated control name and uses the running sum property. No luck. The name of the dcount calculated control is txtCountDisposition. The name of the running sum control is txtSums with the control source set to =txtCountDisposition. The running sum control is in the report footer. Any ideas? Thanks. Michael |
#2
|
|||
|
|||
Sum DCOUNT Calculated Control
Michael wrote:
Hi Folks - I am using DCOUNT like this: =DCount("disp1","qrycombinedispositions","disp=qr ycombinedispositions.disp1") I am counting the number of different dispositions based on a control in the report. It works fine. I'd like to sum the individual counts into a grand total. I realize you cannot sum a calculated control. I've tried the workaround of using another text box control that sets the control source to the calculated control name and uses the running sum property. No luck. The name of the dcount calculated control is txtCountDisposition. The name of the running sum control is txtSums with the control source set to =txtCountDisposition. The running sum control is in the report footer. The RunningSum text box must be in the same section as the DCount text box. The text box in the report footer displays the grand total by using the expression =txtSums -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Sum DCOUNT Calculated Control
I don't see how
=DCount("disp1","qrycombinedispositions","disp=qry combinedispositions.disp1") works to display any accurate results. It is basically the same as =DCount("disp1","qrycombinedispositions","disp=dis p1") Can you tell us the actual expression and something about the record source of the report? -- Duane Hookom Microsoft Access MVP "Michael" wrote: Hi Folks - I am using DCOUNT like this: =DCount("disp1","qrycombinedispositions","disp=qry combinedispositions.disp1") I am counting the number of different dispositions based on a control in the report. It works fine. I'd like to sum the individual counts into a grand total. I realize you cannot sum a calculated control. I've tried the workaround of using another text box control that sets the control source to the calculated control name and uses the running sum property. No luck. The name of the dcount calculated control is txtCountDisposition. The name of the running sum control is txtSums with the control source set to =txtCountDisposition. The running sum control is in the report footer. Any ideas? Thanks. Michael |
Thread Tools | |
Display Modes | |
|
|