Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count of Records (2003)

    I am creating a report based off of an audit on our nursing floors. There are many detail records under each floor. What I need is to know how many floors we audited and the number of records per floor.

    So, how do I count the floor 1 time but all the records underneath. Example...CCU and 5th floor....2 floors but 30 records for CCU and 20 for 5th and of course for grand totals...2 floors with a combined total of 50 records.

    Thanks
    Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Count of Records (2003)

    Open the report in design view.
    Activate the Sorting and Grouping window (if it isn't visible, select View | Sorting and Grouping).
    Make sure that the field that identifies the floor has been added to this window, and that the Group Header and/or Group Footer property has been set to Yes.

    Place a text box in the group header or group footer with control source <code>=Count(*)</code>
    This displays the number of records per floor.

    Place a text box with the same control source in the report footer. This displays the total number of records.

    Place another text box in the group header or group footer, with control source <code>=1</code>
    Set its Running Sum property to Over All, its Visible property to No and name it txtFloors.
    Place a text box in the report footer with control source <code>=[txtFloors]</code>
    This text box displays the number of floors.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count of Records (2003)

    PERFECT!!!!!

    Thanks

  4. #4
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count of Records (2003)

    OK....I got a problem.

    Boss wants me to put my totals on the first page.....
    When I move my totals to the page header...it does not calculate correctly.

    HELP.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Count of Records (2003)

    Try putting them in the report header instead of in the page header.

Posting Permissions

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