Count dupliate names within a report

[jeffreybrown]

I have a report with a query as the control source. Because of multiple tables the query is producing duplicate names which is fine as one field makes each record unique.

On the form in a textbox I have =Count(*) which counts all of the records, but it's counting the duplicate names as one.

How can I get the count to eliminate and give a count of unique names?

 

[pbaldy]

One way is a hidden textbox in the group header with a control source of

=1

and a running sum of Over Group.

Then in the report footer a textbox:

=TextboxName

referring to the textbox in the group header.

 

[jeffreybrown]

Hi Paul and thanks for the direction. I'm a little lost on the Group header part. I see in the report Report header and Page header, but how do I get the Group header?

 

[pbaldy]

With the report in design view, click on the Group & Sort icon on the ribbon. That will open a box at the bottom where you can add the appropriate grouping. If you want, you can make the textbox really small and shrink the group header so it doesn't show. I thought you might already be using it.

 

[jeffreybrown]

Perfect. Thank you so much Paul. I'm a little dense but finally figured out what you were saying. So many cool things to do in Access.

 

[pbaldy]

Happy to help, and welcome to the site by the way!