Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Queries

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-24-2010, 08:25 AM
Brian62 Brian62 is offline Windows XP Access 2007 (version 12.0)
Advanced Beginner
 
Join Date: Aug 2009
Posts: 85
Brian62 is on a distinguished road
Default 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 *" "*
Reply With Quote
  #2  
Old 05-24-2010, 09:03 AM
kimmer kimmer is offline Windows 7 Access 2010 (version 14.0)
Advanced Beginner
 
Join Date: May 2010
Posts: 78
kimmer is on a distinguished road
Default

Place in critera row for the field in the query:

Like *&[Enter Keyword:]&*
Reply With Quote
  #3  
Old 05-24-2010, 09:14 AM
Brian62 Brian62 is offline Windows XP Access 2007 (version 12.0)
Advanced Beginner
 
Join Date: Aug 2009
Posts: 85
Brian62 is on a distinguished road
Default

Thanks! Worked perfectly!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query To search Two Tables stu_C Queries 5 03-25-2010 09:50 AM
Search with in a Query AccessCodeMonkey Queries 4 03-09-2010 12:16 PM
Search DWS Forms 3 08-24-2009 10:07 AM
yes/no search query islandboy Queries 7 06-30-2009 07:01 AM
Run a search query from MS Access using php suba Queries 0 04-26-2009 10:30 PM


All times are GMT -8. The time now is 10:13 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.