Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    California
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counts in Reports

    I am very new to Access, trying to do something that seems simple. I would like a count of the number of records in a Group to appear in the Group Footer, and then a grand total of all the counts at the end of the report. I cannot figure out how to do this. Can anyone help?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counts in Reports

    In the group footer insert a text box with the recordsource

    =Count([somefield])

    where "somefield" is the name of the field on the report you wish to count.

    To get the grand total in the rpeort footer, copy the text box in the group footer and paste it into the report footer.


    Richard Aheron
    raheron@hotmail.com
    Richard

  3. #3
    Lounger
    Join Date
    Apr 2001
    Location
    California
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counts in Reports

    Thanks very much. That does the trick.

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counts in Rpts Calvin House please read

    Greetings,

    I just wanted add, if you use Count([SomeField]) in the Group Footer and in the Report Footer, you get a count for those records where [Somefield] is not Null. Therefore you may not get a true record count.

    To get a count regardless of whether a field is blank or not use =Count(*) in the Group Footer and the Report Footer. You will get an accurate count of records.
    (If you like, this is documented in Access' Help)

    Respectfully,
    TomG

Posting Permissions

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