Counting the number of records in a report and returning a percent

[Guest]

Is there a way in Access to count the number of records returned in a group
on a report then turn that number into a percentage of the total number of
records?

 

[Duane Hookom]

You can add a text box to your report header:
Name: txtCountAll
Control Source: =Count(*)

Add a control to your group header or footer
Control Source: =Count(*)/txtCountAll

 

[Guest]

I have one step further that I have a question on. I have a field called CPT
and it contains 112 records. There are duplicates in this field which is
fine, but I want to count the number of unique records which I know is 80.
How can that be done? I just want the "80" displayed on the report.

Thanks.

 

[Duane Hookom]

Create a query that groups by CPT. Then add a text box to your report:
=DCount("*","qgrpCPT")
where qgrpCPT is your group by query.