filtered report results count?

  • Thread starter Thread starter Craig Armitage
  • Start date Start date
C

Craig Armitage

Hi,

is it possible to include the count of records displayed in a report thats
been filtered?

Thanks

Craig
 
Add a text box the the Report Footer section.

Set the Control Source property of this text box to:
=Count("*")

(If you don't see a Report Footer section, it's on the View menu.
Don't use the Page Footer section.)
 
Allen,

Is it possible to get the total number of no filtered result for calculating
the percentage of filtered records?

Thanks,

Scott
 
Not sure exactly what you are asking there.

You can perform any calculation in the Report Footer section, such as
summing columns and then expressing one column as the percentage of another.

If you want to calculate each Detail section record as a percentage of the
total, try putting the totals in the Report Header section. Access actually
makes 2 passes, so that sometimes works.
 
You must log in or register to reply here.

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

Access report preview and print only the first page 2
need help on either doing a loop and counting specific values orusing subtotal function 2
Changing object properties from a macro? 1
This probably isn't possible 11
report/query settings 5
Access Dcount (multiple criteria) 3
conditional reporting 4
Email report that is filtered to one record 7

Back
Top