Unique counter in section HEADER

[PK]

I have a report with several groupings - two of which are Category and
ProjID. I need the HEADER section for Category to have a UNIQUE count of
ProjID.

Here is what I have so far, which WORKS FINE for the Category footer, but
when i move it to the header it doesnt work.

text control in ProjID sort footer:
name: ProjCounter
control source: =1
running sum: Over Group

text control in Category footer
name: SectionProjCounter
control source: =[ProjCounter]
running sum: No

SectionProjCounter works FINE in the footer, but not in the header - Please
Help!

 

[PK]

No-one have an answer?

 

[John Spencer]

You can try this, I'm not sure it will work. You can test and see.

Leave SectionProjCounter in the footer.

Add a new control in the CategoryHeader
Name: SectionProjCounterHDR
Control Source: = [SectionProjCounter]

It is possible that it will get the correct value, get the value for the
previous group, fail with an error, etc.

Another option might be to use Allen Browne's Ecount function.

Okay, this gets asked reasonably often, so here is a new article:
ECount() - an extended DCount()
at:
http://allenbrowne.com/ser-66.html

ECount() takes the same arguments as DCount(), but an extra flag you can set
to retrieve the distinct count.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

No-one have an answer?

I have a report with several groupings - two of which are Category and
ProjID. I need the HEADER section for Category to have a UNIQUE count of
ProjID.

Here is what I have so far, which WORKS FINE for the Category footer, but
when i move it to the header it doesnt work.

text control in ProjID sort footer:
name: ProjCounter
control source: =1
running sum: Over Group

text control in Category footer
name: SectionProjCounter
control source: =[ProjCounter]
running sum: No

SectionProjCounter works FINE in the footer, but not in the header - Please
Help!