Group Totals

[Aaron Neunz]

I am designing an Access report. The control source for my report is a
query with four columns of data.
Two columns PRECNAME and PRECCODE may have duplicate records, all of which I
need to appear on my report are doing so just fine.
I have created an invisible text box with a control source =1 in the
details section and another visible text box in my group footer section
with the control source of that text box. However I only would like a count
of the total number of DISTINCT records in each group. How can I accomplish
this?

 

[John Vinson]

However I only would like a count
of the total number of DISTINCT records in each group. How can I accomplish
this?

Set the Running Sum property of the textbox to "Over Group".

John W. Vinson[MVP]

 

[Aaron Neunz]

I set that property, however my totals are still not distinct.

Thanks

 

[John Vinson]

I set that property, however my totals are still not distinct.

What's the Recordsource of the report? What do you have in its Sorting
and Grouping? What are you seeing, and what do you want to see?

John W. Vinson[MVP]

 

[Aaron Neunz]

The Recordsource of the report is a query consisting of four columns of
data:
USCONG, PRECCODE, SPLIT, & PRECNAME
First I am grouping by USCONG which results in three groups on my report and
is working correctly.
I need to count the number of distinct PRECNAMEs (or PRECCODEs will work) in
each group of USCONGs. On my report I am receiving 318.
I should be seeing 274.
I have an invisible text box named RecordCount in my detail section with a
control source =1 and the running sum property set to Over Group. I have
another text box with a Control Source =[RecordCount].