Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    2

    Newbie filter question

    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!

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Try this:

    Like "paxil*" Or Like "tamoxifen*"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form Based Query/Filter
    By Micon in forum Access
    Replies: 0
    Last Post: 11-07-2008, 09:25 AM
  2. Open a table in a From based on a filter
    By turbobeagle in forum Forms
    Replies: 1
    Last Post: 01-11-2008, 12:27 PM
  3. Newbie question
    By The_Dude in forum Programming
    Replies: 2
    Last Post: 12-23-2007, 07:11 PM
  4. Newbie question
    By benplace in forum Queries
    Replies: 1
    Last Post: 12-13-2005, 06:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums