Query Problem: Trying to make a query search faster

I'm not sure what to put in the title but ill explain my problem.

I want to make my queries faster and easier to use. My basic query system is
used to quickly search for customer details. Now heres my problem. I have a
customer that lives in a street called

Cherry Tree Drive

The problem is to get the customers details when I query I have to type the
full thing, not only that but it also will have to be a 100% match is
spelling etc.
Now what I want to do is be able to speed up searching.
So if I typed,

Cher

or

Drive

It would search my database and bring up all of my records with the letters
"cher" or "Drive" in that exactorder. I'm not sure if It can be done but it
would be really helpfull if someone could tell me what I need to input to
make the query work how I want,

Thanks,
Sacred

Answered in m.p.a.forms

Which ones that? Ive just checked the other place I posted it but cant see
it.
(http://www.microsoft.com/office/comm...a ng=en&cr=US)

Regards,
Sacred

"Allen Browne" wrote:

Answered in m.p.a.forms