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

    Newbie 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
    Join Date
    Sep 2005
    Posts
    3
    Have you tried to use “OR” criteria instead of “AND”?

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

Similar Threads

  1. newbie questions
    By bigmac in forum Access
    Replies: 0
    Last Post: 10-07-2008, 12:53 AM
  2. newbie needs design help
    By ashiers in forum Database Design
    Replies: 0
    Last Post: 09-13-2008, 07:05 PM
  3. An oldie but newbie
    By GTodd in forum Access
    Replies: 1
    Last Post: 06-25-2008, 08:15 AM
  4. Newbie question
    By The_Dude in forum Programming
    Replies: 2
    Last Post: 12-23-2007, 07:11 PM
  5. Newbie filter question
    By benplace in forum Access
    Replies: 1
    Last Post: 12-03-2005, 08:31 AM

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