Query for mulitple codes under one provider

For users or potential users.
Post Reply
bennettddsOM
Posts: 1
Joined: Fri May 15, 2015 8:11 am

Query for mulitple codes under one provider

Post by bennettddsOM » Fri May 15, 2015 8:24 am

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

Post Reply