count distinct on a report?

[Lifeseeker]

Hi,

I have a report that has two levels of information.

Is there any way to count the first column distinctively?

Please see the example below:

00001
abc
cde
erd

Right now, it's counting 3 records of 00001 instead of 1. I want it to show 1 on the report to say there is ONE 00001

Is there a way to do this?

comments/help much appreciated.

 

[Beetle]

You do this in the Sorting/Grouping of the report. Select the field you want to sort by, set Group Header to Yes, put the Control for that field in the Group Header section of the report and leave other Controls in the Detail section.

 

[Lifeseeker]

You do this in the Sorting/Grouping of the report. Select the field you want to sort by, set Group Header to Yes, put the Control for that field in the Group Header section of the report and leave other Controls in the Detail section.

Hi,

I attached a screenshot of the report in design. It seems I have everything you specified. The total still shows the record total instead of a count of fee_num.

Thank you

 

[Beetle]

Maybe I should learn to read the question before posting an answer

You said you want to count each group (I think). You still would have needed to do what I suggested earlier, but in addition to that you need to add a Group Footer to your group, move the calculated text box from the Report Footer to the Group Footer and change the Control Source of the text box to;

=Count([YourField])

 

[Lifeseeker]

You do this in the Sorting/Grouping of the report. Select the field you want to sort by, set Group Header to Yes, put the Control for that field in the Group Header section of the report and leave other Controls in the Detail section.

thank you it worked.