Autonumber as a result of a query

G

Gregory Jones

I am looking to find the top ten diagnosis codes used by
each physician in my medical group.

I need a list of 10 diagnosis codes for each physician
based on his 10 most utilized codes.

It would be simple if I could run a query that sorts the
physicians in ascending and sort the count of diagnosis
codes in descending. Then start a counter that reverts
back to 1 at the start of a new physician.

Hope this makes sense.....Thanks in advance for any input.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top