Figure a percentage using the Count(*) function in a report header

  • Thread starter ILoveAccess via AccessMonster.com
  • Start date
I

ILoveAccess via AccessMonster.com

I am using the Count(*) function in the Report Header to count how many
records are in the whole report. Also I am using the Count(*) function in my
Group Header called "Status" . An example of a "Status" is "QUOTING". I
want to know the percentage of each status versus the total number of leads
in the whole report.


EXAMPLE:


Total # "Status" Records / Total number of ALL records
 
M

Marshall Barton

ILoveAccess said:
I am using the Count(*) function in the Report Header to count how many
records are in the whole report. Also I am using the Count(*) function in my
Group Header called "Status" . An example of a "Status" is "QUOTING". I
want to know the percentage of each status versus the total number of leads
in the whole report.

EXAMPLE:

Total # "Status" Records / Total number of ALL records
Click to expand...


Just use a text box with an expression like:
=groupheadertextbox / reportheadertextbox
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A03 - count in report footer gives me #Error? 0
Percentage function in a report 1
How to count records using count(*) in a chart report 3
Count and Filter Result 16
Bound Chart in Report Issues - Access 2007 4
counting records 0
Count 3
How do I count selected data in a report footer 1

Top