Sub Summary count for a field
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
Create a summary field that uses Count ( I would pick the primary ID key as the field to count ).
Then put this summary field in the subsummary part.