I am looking for a query that will allow us to pull all codes associated with a hygiene visit for a specific provider within a date range. I see one query (883) that allows for one code but I am hoping to find someone who may be able to tweak that query to allow multiple codes. (open dental is also looking into it)
My end result is to find production totals for a hygiene room/provider for a date range. I want it to also account for xrays, exams, any codes for production from that room/provider.
Should the Doctor also have hygiene patients, I would also like to pull up their production history for a date range.
We are putting together reports for a management company and have a deadlines coming up for data.
Thoughts?
Thank you!
Nancy
Query for mulitple codes under one provider
-
- Posts: 1
- Joined: Fri May 15, 2015 8:11 am