Select names begining w/same ltr in query

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!

re: Select names begining w/same ltr in query

Minitman wrote:
[color=blue]
> 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.[/color]

put Like before your prompt expression in the query designer.

Like [Print first letter]

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

re: Select names begining w/same ltr in query

On 03 Feb 2004 22:09:16 GMT, Minitman <dick@briggs.cc> wrote:
[color=blue]
>
>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![/color]

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

re: Select names begining w/same ltr in query

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!

re: Select names begining w/same ltr in query

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!