SUMMARY REPORT...

  • Thread starter Thread starter Ray W.
  • Start date Start date
R

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.
 
Ray said:
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.
Click to expand...

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