There is no reason why the query in AC should bring over active and well as inactive meds other than someone else thought it was a good idea to do so. One possible reason is seeing the med history may affect a doctor's thought process on what to give the patient next. For example, 6-month follow-up and the doctor decides to give the patient a new med, pulls up the chart and sees, "Wait, I tried that one two years ago. Never mind."

I'm completely making that up, but you get the point. Active and Inactive meds can be separated. My process to convert AC databases to PDF does so. You get two meds lists. One for active, one for inactive.

JamesNT

Last edited by JamesNT; 03/18/2024 9:08 PM.

James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net