Go to reports -> Medications -> Medication Name (Active) = apraclonidine
Add criteria to Query.
Go to reports -> Medications -> Date Last Refills = (in Value put date this occurred)
Add criteria to Query.
Run report. Every patient who had clonidine change to apraclonidine will show up in Query Results.
Change back to clonidine one at a time.
If you have 100 patients now showing apraclonidine. You can change them back to clonidine by doing it in reverse. If you have 100 patients showing apraclonidine and 7 of those are really on it, the change those to a drug like Zebra capsules 10 mg. Do the change, then change those back.
Or alternatively, write the patients' names down, and go back and change those from clonidine to apraclonidine.
If you think each step through one at a time, you will do fine. I agree with Wendell's approach, I would just add putting in the criteria for that date. That way everyone who comes up will be the one's affected (unless of course, they were prescribed clonidine that day) in which case you could run a clonidine prescription report for everyone who was prescribed clonidine for that day.
