Computing.Net > Forums > Programming > Access query criteria

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access query criteria

Reply to Message Icon

Name: Mark Pratt
Date: June 5, 2003 at 14:47:19 Pacific
OS: Windows 2000
CPU/Ram: p4 2.5g 512mb
Comment:

I am trying to setup a query that prompts the user with a dialog box that will accept text for the search, and then return all entries that contain any portion of that text.

On the criteria line of the Select Query box I try and enter the following: * [Enter search:] *

Access reformats that to: Like "*" And [Search For Name] And Like "*"

Can someone offer a tip? I am brand new to access, as may be obvious with the question.




Sponsored Link
Ads by Google

Response Number 1
Name: mark
Date: June 6, 2003 at 07:55:54 Pacific
Reply:

your nearly there it should be

like "*" + [entervalue] +"*"

that will work

rgds


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Access query criteria

Access - Query Question www.computing.net/answers/programming/access-query-question/13599.html

MS-ACCESS Query www.computing.net/answers/programming/msaccess-query/6852.html

Access queries www.computing.net/answers/programming/access-queries/10453.html