query help

For users or potential users.
Post Reply
babysilvertooth
Posts: 129
Joined: Sat Jun 12, 2010 3:18 pm

query help

Post by babysilvertooth » Sat Dec 15, 2012 2:33 pm

I am trying to find a query for the top 50 Procedures done for the year, with their 'average' fee, my standard fee, and the produciton from that procedure code.

I tried a few queries that I found, but I couldn't get one that shows me my 'standard' fee along with the total prod.

Thanks for the help

bpcomp
Posts: 304
Joined: Mon Feb 27, 2012 7:30 am
Location: Tucson, AZ
Contact:

Re: query help

Post by bpcomp » Mon Dec 17, 2012 6:32 am

Whats the query that comes close to what you want?

User avatar
jsalmon
Posts: 1555
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: query help

Post by jsalmon » Tue Dec 18, 2012 9:40 am

If all else fails we can write the custom query for you. We charge $90 an hour to write them though because we have lots of requests for them.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply