Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Frederick, Maryland, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Number of Records in a Report (A2K SR1)

    I have a report that is populated by a query. In the Report Footer, I'd like to place a text box that presents the total number of records in the report. 1) How do I count the number of records? and 2) How do I present that number in a report? I realize this is probably a very simple task, so please forgive my brain fade. Thank you for your help.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Number of Records in a Report (A2K SR1)

    Add a textbox to your Report Footer, and set its controlsource to:
    =Count(*)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •