AnsweredAssumed Answered

Sub Summary count for a field

Question asked by kilbot on Feb 4, 2010
Latest reply on Feb 4, 2010 by mrvodka

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

Outcomes