Sum DCOUNT Calculated Control

[Michael]

Hi Folks - I am using DCOUNT like this:

=DCount("disp1","qrycombinedispositions","disp=qrycombinedispositions.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

 

[Marshall Barton]

Hi Folks - I am using DCOUNT like this:

=DCount("disp1","qrycombinedispositions","disp=qrycombinedispositions.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

 

[Duane Hookom]

I don't see how

=DCount("disp1","qrycombinedispositions","disp=qrycombinedispositions.disp1")
works to display any accurate results. It is basically the same as
=DCount("disp1","qrycombinedispositions","disp=disp1")

Can you tell us the actual expression and something about the record source
of the report?