I'm obviously not advanced enough to write my own queries judging by my last 4 hours worth of work.
I'd like a query of all active patients who have not been in for an adult prophy, child prophy, perio maintenance or SRP for the last six months. We got our recall all screwed up and I need this list.
Also, while I'm asking for favors, is there a way to write a query to see how many patients have been in for two hygiene procedures within the last 12 months? Trying to get an active patient count in our hygiene dept.
-thanks