For users or potential users.
-
DavidWolf
- Posts: 259
- Joined: Tue Jun 19, 2007 9:39 am
- Location: Milford, MA
-
Contact:
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
- Posts: 149
- Joined: Tue Jun 26, 2007 8:13 pm
- Location: IL
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
- Posts: 149
- Joined: Tue Jun 26, 2007 8:13 pm
- Location: IL
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!!