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.
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.