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

Parameter Query - how to avoid needing wildcards

P: n/a
dnl
I have a parameter query that I would like to simplify so that I wouldn't
need to use wildcards when entering in partial data. The following line is
in the criteria field when designing the query:

Like [Enter last name]

Running the query brings up the dialog box to enter the parameter. If the
name I am looking for is Smith, I can type "smi*" to do a wildcard match.
Is there anyway to avoid needing the wildcard? I'd like my less-
knowledgeable database users to not have to remember the wildcard. If they
are looking for "Smith" I'd like them to just type in "smi" and have it
bring up all names that start with "smi". Any suggestions?

Thanks.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Like [Enter last name] & "*"

Nov 13 '05 #2

P: n/a
On Tue, 31 May 2005 17:22:33 -0500, dnl wrote:
I have a parameter query that I would like to simplify so that I wouldn't
need to use wildcards when entering in partial data. The following line is
in the criteria field when designing the query:

Like [Enter last name]

Running the query brings up the dialog box to enter the parameter. If the
name I am looking for is Smith, I can type "smi*" to do a wildcard match.
Is there anyway to avoid needing the wildcard? I'd like my less-
knowledgeable database users to not have to remember the wildcard. If they
are looking for "Smith" I'd like them to just type in "smi" and have it
bring up all names that start with "smi". Any suggestions?

Thanks.


To search for records that begin with the entered phrase, i.e. "smi":
Like [Enter Last name] & "*"

To search for records that end with the entered phrase:
Like "*" & [Enter Last name]

To search for records that contain the phrase anywhere in the field:
Like "*" & [Enter Last name] & "*"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #3

P: n/a
dnl
fredg <fg******@example.invalid> wrote in
news:1q*******************************@40tude.net:
On Tue, 31 May 2005 17:22:33 -0500, dnl wrote:
I have a parameter query that I would like to simplify so that I
wouldn't need to use wildcards when entering in partial data. The
following line is in the criteria field when designing the query:

Like [Enter last name]

Running the query brings up the dialog box to enter the parameter. If
the name I am looking for is Smith, I can type "smi*" to do a
wildcard match. Is there anyway to avoid needing the wildcard? I'd
like my less- knowledgeable database users to not have to remember
the wildcard. If they are looking for "Smith" I'd like them to just
type in "smi" and have it bring up all names that start with "smi".
Any suggestions?

Thanks.


To search for records that begin with the entered phrase, i.e. "smi":
Like [Enter Last name] & "*"

To search for records that end with the entered phrase:
Like "*" & [Enter Last name]

To search for records that contain the phrase anywhere in the field:
Like "*" & [Enter Last name] & "*"


Fred and Chuck, Thanks so much!!
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.