Results 1 to 2 of 2
  1. #1
    netchie is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    92

    Query: How To Filter Data In Criteria

    Hi,

    I have a data in my query that I need to filter. I want to filter anything that has:

    "HOLD (with numbers included with it)"
    "Reserve 888"
    "Reserve 865"

    What can I put in criteria for all of these so they won't show up on my report?



    Thanks,
    netchie

  2. #2
    netchie is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    92
    Nevermind; I already got the correct formula

    Thanks,
    netchie

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

Similar Threads

  1. Query Criteria Causing Data Mismatch Error
    By jrubenol in forum Queries
    Replies: 2
    Last Post: 09-14-2011, 09:34 AM
  2. Filter SQL query by criteria
    By IdleJack in forum Access
    Replies: 2
    Last Post: 08-18-2011, 05:56 PM
  3. Inch symbol in query filter criteria
    By sprovoyeur in forum Queries
    Replies: 3
    Last Post: 10-01-2009, 11:24 AM
  4. Replies: 6
    Last Post: 09-25-2009, 12:40 PM
  5. Criteria or Filter for Query
    By Ryan in forum Queries
    Replies: 1
    Last Post: 08-29-2009, 11:50 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