Hopefully I can explain this so you understand what I am trying to do.

I am working on a patient billing report.
My issue is that a patient can have a procedure done 2-3-4 times.

It will look like this if I don't distinct:

procedure 1: Quantity: 1
procedure 1: Quantity: 1
procedure 1: Quantity: 1

I need the result to look like this:

procedure 1: Quantity 3

I have the billing data all on one detail page pr. procedure, so when the procedure number changes, it shows on next page, along with all patient demographics etc. I just don't need 3 pages for a procedure done 3 times, when I can count it and put the count on one page. I just don't know how.

How can this be done?

Appreciate any assistance.