Total patient visits query

For users or potential users.
Post Reply
Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Total patient visits query

Post by Tom Zaccaria » Tue Apr 25, 2017 10:46 am

I am looking for a query to total the patient visits by time period, usually for one month, and by insurance carrier. Something like this with a total per carrier and per month;

Patient visits
CarrierName................................Jan...Feb...March../.....Total
Aenta Medicare Hmo Premier.............1.....2.......2
Aetna DMO..................................11....3.......3
Aetna PPO...................................14....10......15

Total..........................................26....15......19

Query #87 gives me what I want but I need to manually run it every month and then consolidate everything on an Excel spreadsheet. Anyone have anything like this or do i have to request a custom query?
Thanks,
drtmz

User avatar
Tralston
Posts: 9
Joined: Tue Nov 26, 2013 1:11 pm
Location: Salem, OR
Contact:

Re: Total patient visits query

Post by Tralston » Tue May 02, 2017 7:10 am

Having looked through our query examples and testing quite a few, I have not found anything that will do exactly what you are looking for. The best recourse would be to submit a query request that we can work with you on to meet your needs. If you include information regarding the specific query you are using now that is often helpful.
Timothy Ralston
Open Dental Software
http://www.opendental.com

Post Reply