Query problem, shortening a query can anyone help?

I'm trying to make a query system and want to speed up the way it is used.

Basically I might be wanting a query on a street name. The street name is:

Cherry Tree Drive

I set up the query as normal and have it so I need to type in a street name
before it can find anything. The problem is this can be time consuming and is
relient on 100% correct spelling.
I want it so I can type say

Cher

and it would find

Cherry Tree Drive (and anyother with them matching letters)

I'm not sure how to do this exactly so thought someone here might be able to
help.

Thanks,
Sacred

In the Criteria:
Like "Cher*"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sacred" wrote in message
...
I'm trying to make a query system and want to speed up the way it is used.

Basically I might be wanting a query on a street name. The street name is:

Cherry Tree Drive

I set up the query as normal and have it so I need to type in a street
name
before it can find anything. The problem is this can be time consuming and
is
relient on 100% correct spelling.
I want it so I can type say

Cher

and it would find

Cherry Tree Drive (and anyother with them matching letters)

I'm not sure how to do this exactly so thought someone here might be able
to
help.

Thanks,
Sacred

Good morning

In the Criteria area of your query, enter the following for the appropriate
field you wish to query on:

Like "*" & [FieldToQuery} & "*"


Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.


I'm trying to make a query system and want to speed up the way it is used.

Basically I might be wanting a query on a street name. The street name is:

Cherry Tree Drive

I set up the query as normal and have it so I need to type in a street name
before it can find anything. The problem is this can be time consuming and is

relient on 100% correct spelling.
I want it so I can type say

Cher

and it would find

Cherry Tree Drive (and anyother with them matching letters)

I'm not sure how to do this exactly so thought someone here might be able to
help.

Thanks,
Sacred

You can use the like operator to do this:

SELECT StreetName
FROM (NameofTable)
WHERE StreetName Like ("*"&[NameoftextBox]&"*");

This way, if you enter Ch in the text box, it will retrun any fields that
contain Ch in them anywhere.

hope this helps,
Chad

"Sacred" wrote:

I'm trying to make a query system and want to speed up the way it is used.

Basically I might be wanting a query on a street name. The street name is:

Cherry Tree Drive

I set up the query as normal and have it so I need to type in a street name
before it can find anything. The problem is this can be time consuming and is
relient on 100% correct spelling.
I want it so I can type say

Cher

and it would find

Cherry Tree Drive (and anyother with them matching letters)

I'm not sure how to do this exactly so thought someone here might be able to
help.

Thanks,
Sacred