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

    How to Search for keywords in a Query


    I have a query that I want to be able to change my search criteria by keyword(s). I want it to be able to ask me to enter keyword to search for so I can filter it to a report.

    Here is what I have tried with no success:

    Search for Keyword: Enter Keyword [" "]
    Search for Keyword: Enter Keyword *" "*

  2. #2
    kimmer is offline Competent Performer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    100
    Place in critera row for the field in the query:

    Like *&[Enter Keyword:]&*

  3. #3
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147
    Thanks! Worked perfectly!

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

Similar Threads

  1. Query To search Two Tables
    By stu_C in forum Queries
    Replies: 5
    Last Post: 03-25-2010, 11:50 AM
  2. Search with in a Query
    By AccessCodeMonkey in forum Queries
    Replies: 4
    Last Post: 03-09-2010, 03:16 PM
  3. Search
    By DWS in forum Forms
    Replies: 3
    Last Post: 08-24-2009, 12:07 PM
  4. yes/no search query
    By islandboy in forum Queries
    Replies: 7
    Last Post: 06-30-2009, 09:01 AM
  5. Replies: 0
    Last Post: 04-27-2009, 12:30 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