EXACT MATCH Problem, PLEASE HELP!!!

B

Bryan Allen

We are using Access as the database for our website of music. When you search
for "ARTIST", you must type in the exact match in a field to return any
results. Our fields are formatted Last Name, First Name - Therefore, if
someone types in Elvis Presley instead of Presley, Elvis it returns no
results. Only if you type Presley, Elvis does it return any results. It also
works with individual names such as Elvis or Presley seperately. This is
quite annoying... Please help! We want the customers to be able to type in
any varation and get results. HELP!!!!
 
J

Jeff Boyce

Bryan

You described what you're doing, but not how your data is organized.

In a well-normalized design, I'd suggest that you build a combo box based on
your Artist table, then use the ArtistID to select related records.

Good luck

Jeff Boyce
<Access MVP>
 
B

Bryan Allen

Dear Jeff,
Thanks for responding. I'm sorry that i didn't describe the problem
clearly. This is the link to the site:
http://www.vinylcastle.com/Vinyl2_Connection_interface/45s/Search_for_Records.asp

The problem that we are having is that if you type in any query other than
the exact match for the record, it shows no results. So for example...if you
search for Elvis Presley you get no results. You can only get results if you
type Presley, Elvis....the exact match. This is really inconveinent for
customers. Any way to alleviate this? Your help is GREATLY appreciated!!!!
 
J

John Vinson

Thanks for responding. I'm sorry that i didn't describe the problem
clearly. This is the link to the site:
http://www.vinylcastle.com/Vinyl2_Connection_interface/45s/Search_for_Records.asp

The problem that we are having is that if you type in any query other than
the exact match for the record, it shows no results. So for example...if you
search for Elvis Presley you get no results. You can only get results if you
type Presley, Elvis....the exact match. This is really inconveinent for
customers. Any way to alleviate this? Your help is GREATLY appreciated!!!!
Click to expand...

Jeff and the rest of us understand your *problem* just fine. The link
to the site does NOT answer Jeff's very relevant question, however -
*how do you have the data stored in your table*.

Note that a Query using the LIKE operator lets you search for a
substring anywhere in a field: a criterion on ARTIST of

LIKE "*ELVIS*"

will find "Presley, Elvis" or "Elvis Presley" (and also find Elvis
Costello of course).

John W. Vinson[MVP]
 
J

Jeff Boyce

Thanks, John.

I don't believe I've ever been accused of "relevancy" before <g>!

Jeff
 
Top