srburk
07-09-2004, 12:52 PM
I am trying to determine the top 20% medications used in each clinic at a hospital. How can I create a query and or report to show me only the top 20% (per clinic)?
Example of entry:
Medication Clinic Totals
FAMOTIDINE 20 MG TAB NGI 8
LANOXIN 0.25 MG TAB NGI 2
METHOTREXATE 10 MG NGI 1
There are multiple clinics. There are over 50,000 total records. I just want the report to list the top 20%. :confused:
Example of entry:
Medication Clinic Totals
FAMOTIDINE 20 MG TAB NGI 8
LANOXIN 0.25 MG TAB NGI 2
METHOTREXATE 10 MG NGI 1
There are multiple clinics. There are over 50,000 total records. I just want the report to list the top 20%. :confused: