Link to home
Start Free TrialLog in
Avatar of spattewar
spattewar

asked on

How to put Table Record Count on an Access Report

Hi Experts,
Thanks for your time.
I have created an access report that show the records from Table A in the report detail part of the report. On the PAge Header of the access report I also want to show the count of rows present in Table A. How do I do that? If I put a text box with the ControlSource =COUNT([Table A]![Field 1] then it gives #error when I run the report.

This may be very easy but I am not able to get it !!!!

Thanks again.
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of spattewar
spattewar

ASKER

Thanks. That works great!!!!

And what if I want to get the recordcount from a Query instead of a table.

I appreciate your help.
THIS IS FANTASTIC.

I was able to get the count by replacing the table name with the query name. I spent so much time on this and at the end your help did it.

Thank you very much!!!

$wapnil
you are welcome. Yes ... table or query name works.

mx