S
Sacred
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
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