Ave Fee/Patient Visit by date range

DavidWolf · Post by **DavidWolf** » Thu Sep 20, 2007 5:44 pm

Here is a query my accountant asked for today, thought I would share it.
Cheers,
DW

SELECT sum(procfee) as 'Total Fee',
COUNT(DISTINCT AptNum) as 'Number Of Appointments',
sum(procfee)/COUNT(DISTINCT AptNum) as 'Ave Fee/Visit' from procedurelog
WHERE procStatus=2
AND procDate>='2007-01-01'
AND procDate< '2007-12-31'

sparkly · Post by **sparkly** » Thu Sep 20, 2007 8:13 pm

thank you so much for this!! my business manager will be like a pig in mud!!

sparkly · Post by **sparkly** » Thu Sep 20, 2007 8:14 pm

thank you so much for this!! my business manager will be like a pig in mud!!