How to put Table Record Count on an Access Report

Posted on 2008-11-19
Last Modified: 2013-11-28
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.
Question by:spattewar
    LVL 75

    Accepted Solution

    =DCount("*", "[Table A]")

    LVL 22

    Author Comment

    Thanks. That works great!!!!

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

    I appreciate your help.
    LVL 22

    Author Comment


    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!!!

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    you are welcome. Yes ... table or query name works.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now