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
Total patient visits query
Re: Total patient visits query
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.