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

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]

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