Results 1 to 2 of 2
  1. #1
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147

    Query filter statement

    My query is a simple query but I can't get the right filter to work. In one of my columns I have "Consent and Regulatory" in the text column.
    I have tried: Like "*Consent*" and returns anything with consent in that column which is great but I also want the choice to select "Regulatory" to return any record with regulatory in it. I rather not have to create a second query to do that. I like to have a popup screen so I can type in one or the other. I have tried "And" and "Or" statements and I can't get them to work in the criteria section.

    I hops this makes sence.

  2. #2
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147
    I figured it out. Here is the cure.
    Like "*" & [Enter: Consent or Regulatory] & "*"

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

Similar Threads

  1. Help with Conditional statement in query
    By Rhues in forum Queries
    Replies: 1
    Last Post: 01-11-2010, 02:09 PM
  2. Criteria or Filter for Query
    By Ryan in forum Queries
    Replies: 1
    Last Post: 08-29-2009, 11:50 PM
  3. I need help writing a query statement
    By dking in forum Queries
    Replies: 1
    Last Post: 02-25-2009, 09:43 AM
  4. If then statement in query
    By ronnie4 in forum Queries
    Replies: 1
    Last Post: 01-20-2009, 10:49 AM
  5. Form Based Query/Filter
    By Micon in forum Access
    Replies: 0
    Last Post: 11-07-2008, 09:25 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