• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

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.
0
spattewar
Asked:
spattewar
  • 2
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
=DCount("*", "[Table A]")

mx
0
 
spattewarAuthor Commented:
Thanks. That works great!!!!

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

I appreciate your help.
0
 
spattewarAuthor Commented:
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
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
you are welcome. Yes ... table or query name works.

mx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now