I am currently running a report that shows ALL meds, but I need a report that shows only "Active" meds if possible. I am using MEDICATE.Description field table in my report. Thanks!
There is a column in MEDICATE called CHANGE. You want all the rows with CHANGE = 2.
I can apply this to patients based on certain obs as well. It will only show patients that have a certain med in the active list and not all list?
As longs as the MEDICATE table is filtered where MEDICATE.CHANGE = 2, only active medications will show. If you can, show me the query you are using for this report, and I can probably see if there would be any issues.
I tried it and it seems to work like it should. Thanks for your help!!
You also want STOPDATE > CurrentDate. Using only Change = 2 will still show inactive meds with all stop dates including those prior to today.