By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

how to search customer name by only enter one letter?

P: n/a
amy
I am new to access, building a query for doctor's info, on the query
design view, Last Name field, how to let people in a pop up window:
"Enter last Name", just put in any first letter to find the last names
begining with that letter. such as type in: y, will give all possible
last names begin with Y, or type in first two letter, or first three
letters... bring all possible matched for the letters in the last name?

I need to use [enter last name] to create the pop up window, but don't
know the rest, try use the LIKE, but don't work.

thanks for help

amy

Apr 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Like [Enter Last Name] & "*"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
"amy" <am******@yahoo.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...
I am new to access, building a query for doctor's info, on the query
design view, Last Name field, how to let people in a pop up window:
"Enter last Name", just put in any first letter to find the last names
begining with that letter. such as type in: y, will give all possible
last names begin with Y, or type in first two letter, or first three
letters... bring all possible matched for the letters in the last name?

I need to use [enter last name] to create the pop up window, but don't
know the rest, try use the LIKE, but don't work.

thanks for help

amy

Apr 12 '06 #2

P: n/a
PC D wrote:
Like [Enter Last Name] & "*"

--
To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Randy Harris
Apr 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.