Group by and Sum

[Guest]

I have a table which has medical visit and payment information.

each patient may have many procedures on the same day.

Fields and sample data as follows.

[Date] [Chart] [Procedure] [Charge] [Payment]
[Adjustment]
01/01/2006 abrme000 97110 $100.00 $75.00 $25.00
01/01/2006 abrme000 98941 $50.00 $40.00 $10.00


I would like to create a report which counts the number of patient visits
and totals each of the financial columns for each day. I only want to count
each patient as one visit a day even though they had several procedures.

I currently have this information on two reports but would like to
consolidate it on to one. Eventually divide the total patient visits for
each day by the total payment to get the average return per visit.

How can I get this information on one report?

 

[Guest]

Hi,
I think you can get what you want by creating a totals query. You would
have date, chart, and your dollar fields selected. You would want to group
by date, group by chart, and sum the dollar fields. Create a report based
off this query.