I have created a query that pulls the following fields from my DB.
Drug
First Name
Last Name
DOB
I created a fitler that only shows like "paxil*", that shows me all patients on paxil, works great. Then I add AND "tamoxifen*" and it returns nothing. I know the problem is because each drug has its own record.
So if Bob Smith is on paxil and tamoxifen, there will be two records for him, one for each drug. How can I filter this information to show me all patients on Paxil and Tamioxifen? Thanks in advance for any help!