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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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.
 
Create a query that groups by CPT. Then add a text box to your report:
=DCount("*","qgrpCPT")
where qgrpCPT is your group by query.
 
Back
Top