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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
mx
ASKER
And what if I want to get the recordcount from a Query instead of a table.
I appreciate your help.