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

Select names begining w/same ltr in query

P: n/a

I have an address database and I want to have the query prompt for me to
enter an expression that will bring up ALL names begining with same
first ltr for individual page on my report. I am familiar with prompt
[Print first letter] in query design but it doesn't bring up all A's or
B's individually. If I type in complete name it brings them up.
If I go in query design and say "B*" it works fine. But I want to be
able to do it on the [ ]prompt.
Thanks for assist
Dick B.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Minitman wrote:
I have an address database and I want to have the query prompt for me to
enter an expression that will bring up ALL names begining with same
first ltr for individual page on my report. I am familiar with prompt
[Print first letter] in query design but it doesn't bring up all A's or
B's individually. If I type in complete name it brings them up.
If I go in query design and say "B*" it works fine. But I want to be
able to do it on the [ ]prompt.


put Like before your prompt expression in the query designer.

Like [Print first letter]

--
Bas Cost Budde
http://www.heuveltop.nl/BasCB

Nov 12 '05 #2

P: n/a
On 03 Feb 2004 22:09:16 GMT, Minitman <di**@briggs.cc> wrote:

I have an address database and I want to have the query prompt for me to
enter an expression that will bring up ALL names begining with same
first ltr for individual page on my report. I am familiar with prompt
[Print first letter] in query design but it doesn't bring up all A's or
B's individually. If I type in complete name it brings them up.
If I go in query design and say "B*" it works fine. But I want to be
able to do it on the [ ]prompt.
Thanks for assist
Dick B.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Like [Enter First Letter] & "*"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal email
Nov 12 '05 #3

P: n/a

Thanks very much for the info. It worked perfect and appreciate your
time.
Dick B.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #4

P: n/a
With the following query procedure from you people - Like[Enter first
letter of last name]&"*" - I thought I was home free. Not quite. When I
run the query by itself for an alpha list for names starting with same
first letter in a last name it works perfect. However when I use the
query as a RECORD SOURCE for my report it doesn't work perfect. In the
case of more than one person with the same last name I only get the
first name and loose the rest??
Thanks again for the assist,
Dick B.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.