Count unique records Problem

[BJ]

Hello everyone,

I would like some help please, I've worked out how to count unique
records using an unbound box =1, running sum Over group.

It does work fine, if i put the result of the count in the footer of
the report.
However i'd like to get that figure in a header above the counters.

Any ideas?

Help appreciated

 

[Duane Hookom]

Is there a reason you are using Running Sum rather than a text box in either
the Report Header or Report Footer with a control source of:
=Count(*)

 

[BJ]

Yes, because i have another header below that then the details.
So in a delivery report i have
the Suburb header, then the address Header, then all the client_id's
that are at that address. As there can be multiple addresses per
suburb. I want the total Addresses per suburb to appear in the suburb
Header. The =Count(*) counts all the client_id's.

Thanks for your response, Duane.

 

[Duane Hookom]

I would create totals queries similar to the report's record source. These
totals queries can group by and count to get the values you want. Place the
final calculation query into the report's record source query so you can use
the values.

 

[Guest]

Sorry to jump in, but I need additional clarification. How does one go about
"Plac[ing] the final calculation query into the report's record source
query"? I believe I could construct the individual totals queries I need for
my particular report, but how to include them in the "larger" query is a bit
of a mystery.

 

[Duane Hookom]

You open the report's record source in the query design view. Select
Query->Show Table and find your totals query. Join the appropriate fields
from your total query and your previous fields.


--
Duane Hookom
MS Access MVP

Sorry to jump in, but I need additional clarification. How does one go
about
"Plac[ing] the final calculation query into the report's record source
query"? I believe I could construct the individual totals queries I need
for
my particular report, but how to include them in the "larger" query is a
bit
of a mystery.
--
Darrell

I would create totals queries similar to the report's record source.
These
totals queries can group by and count to get the values you want. Place
the
final calculation query into the report's record source query so you can
use
the values.

 

[Guest]

An answer on 4th of July! I'm amazed! Thank you! It seems fairly obvious in
retrospect, but I just couldn't see it! So, thank you very much! This solves
at least a major part of my current dilemma. Now for others (such as how to
make one part of the report show certain fields and another part of the
report show others).
--
Darrell

You open the report's record source in the query design view. Select
Query->Show Table and find your totals query. Join the appropriate fields
from your total query and your previous fields.


--
Duane Hookom
MS Access MVP

Sorry to jump in, but I need additional clarification. How does one go
about
"Plac[ing] the final calculation query into the report's record source
query"? I believe I could construct the individual totals queries I need
for
my particular report, but how to include them in the "larger" query is a
bit
of a mystery.
--
Darrell

I would create totals queries similar to the report's record source.
These
totals queries can group by and count to get the values you want. Place
the
final calculation query into the report's record source query so you can
use
the values.

--
Duane Hookom
MS Access MVP

Yes, because i have another header below that then the details.
So in a delivery report i have
the Suburb header, then the address Header, then all the client_id's
that are at that address. As there can be multiple addresses per
suburb. I want the total Addresses per suburb to appear in the suburb
Header. The =Count(*) counts all the client_id's.

Thanks for your response, Duane.

Duane Hookom wrote:
Is there a reason you are using Running Sum rather than a text box in
either
the Report Header or Report Footer with a control source of:
=Count(*)

--
Duane Hookom
MS Access MVP

Hello everyone,

I would like some help please, I've worked out how to count unique
records using an unbound box =1, running sum Over group.

It does work fine, if i put the result of the count in the footer of
the report.
However i'd like to get that figure in a header above the counters.

Any ideas?

Help appreciated