SUMMARY REPORT...

[Ray W.]

I have a query that looks at one particular charge code. It also lists the
many physicians who utilize this charge code. I need a summary report
(Count) of how many times a physician utilizes this charge code:

The report only needs the physician's name once with a sum of how times this
code was utilized by the physician

There are several physicians, I would like all physicians to be on the same
sheet of paper, not individual sheets for each physician.

Thanks,

RayW.

 

[Marshall Barton]

I have a query that looks at one particular charge code. It also lists the
many physicians who utilize this charge code. I need a summary report
(Count) of how many times a physician utilizes this charge code:

The report only needs the physician's name once with a sum of how times this
code was utilized by the physician

There are several physicians, I would like all physicians to be on the same
sheet of paper, not individual sheets for each physician.

Create a Totals query that counts the number of records for
each physician:

SELECT physician, Count(*) As CountOfPhysician
FROM something
WHERE chargecode = [particular charge code]
GROUP BY physician

Change the names of the table/query and fields to whatever
you're using. Then, the summary report should be trivial to
create.