1 Reply Latest reply on Feb 4, 2010 9:28 AM by mrvodka

    Sub Summary count for a field

    kilbot

      Title

      Sub Summary count for a field

      Post

      I have a field in my database called Assigned investigator. I have written a script that pulls up all of my cases and sorts them by the assigned investigator. I have placed in a sub-summary into the layout to be sorted by assigned investigator. In this sub summary I would like to get a count of how many cases the investigator has assigned to them. The assigned investigator field is a text field that operates off of a drop down box.

       

      I think I need to use the count function but I am lost

       

       

      I also would like in my summary a count of the type of cases that investigator has. I have a field called case# and my cases all start with a different letter (a-2000-12-01 or B-2000-11-02) A, B, C, D, E, and G.

       

      Appreciate all of your help