Counting subsets of a field

[DawnLipt]

I am new at this and wasn't even sure how to search to see if this question has been answered.

I want to be able to pull up an employee number and then create a list with a breakdown of how many procedures the person has done by code. A physician may do 50 differently coded procedures. There is a field for the code and a field for the doctor number. So rather than look each one of those up individually, I would think there is a way to create a list that could say that Dr. Smith did 10 of Code 490505, 4 of Code 47563, 30 of Code 19000, etc.

It is probably some simple calculation field, but I am clueless about how to do this.

Thanks,

Dawn

[Fitch]

A subsummary report in the procedures table would be one way to do it.

[DawnLipt]

Thanks, Tom, for your quick reply. I will read how to do the sub summary report and go from there -- but may come back for another question!

Thanks again,

Dawn