Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a field called division in a report that can have one of three values in it.

    The report provides data on students.

    I want to setup a textbox on the report that will count the number of "Lower School" entries in the division field.

    I have tried several varations of the Count() command in the text box but they do not work.

    Can someone help.

    Thanks.

    Paul

  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
    Quote Originally Posted by pbien View Post
    I have a field called division in a report that can have one of three values in it.

    The report provides data on students.

    I want to setup a textbox on the report that will count the number of "Lower School" entries in the division field.

    I have tried several varations of the Count() command in the text box but they do not work.

    Can someone help.

    Thanks.

    Paul
    Try this:
    =sum(IIF(Division="Lower School",1,0))
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2008
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That worked.

    Thanks again.

    Paul

Posting Permissions

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