Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Criteria - LIKE

Status
Not open for further replies.
cbearden

cbearden

Technical User
Joined
May 17, 2004
Messages
80
Location
US
I'm trying to set up my query where I can enter a part of a name and it searches by that. Here's what I put for criteria:

Like "[Enter Name]*"

So if I entered Bob, then all fields starting w/ BOb would come up.

Bob Jones
Bob Smith
Bob Miller

Thanks
 
Sort by date Sort by votes
Like "[Enter Name]" & "*
 
Upvote 0 Downvote


Like[Enter Name]&"*"

(I don't think it will like the quotes around the prompt.)

 
Upvote 0 Downvote
I will try it. Thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

YoBi4Ever
  • Locked
  • Question Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
620
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question Question
Delete query takes FOREVER to run
Replies
11
Views
1K
jedraw
jedraw
Moss100
  • Locked
  • Question Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
459
dhookom
dhookom
qqp
  • Locked
  • Question Question
Need my msgbox that warns user of missing criteria to stop the rest of the code from running
Replies
2
Views
492
Andrzejek
Andrzejek
BradCustom
  • Locked
  • Question Question
Convert Access query to SQL query
Replies
5
Views
547
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top