help: creating an effective search result

[mark | r]

we have a MSAccess database of products with titles, short descriptions,
long descriotions, bulletpoints etc contained for each product.

we currently search the database looking for the target keyphrase within the
fields, but this doesnt give any accurate results as for example a product
that is compativle with "widget 1" is shown before "widget 1"

anyone know of a process that will give us better, more relevant search
results?

mark

[Bob Barrows]

mark | r wrote:

we have a MSAccess database of products with titles, short
descriptions, long descriotions, bulletpoints etc contained for each
product.

we currently search the database looking for the target keyphrase
within the fields, but this doesnt give any accurate results as for
example a product that is compativle with "widget 1" is shown before
"widget 1"

anyone know of a process that will give us better, more relevant
search results?

mark

Sorry. Can't help without more details. Perhaps if you showed us a few rows
of sample data (just the minimum number of fields to illustrate the
problem), the query you are currently using to search the data, the
incorrect result you are getting, and the result you want to get, we would
be better placed to help you.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[mark | r]

> > we have a MSAccess database of products with titles, short

descriptions, long descriotions, bulletpoints etc contained for each
product.

we currently search the database looking for the target keyphrase
within the fields, but this doesnt give any accurate results as for
example a product that is compativle with "widget 1" is shown before
"widget 1"

anyone know of a process that will give us better, more relevant
search results? Sorry. Can't help without more details. Perhaps if you showed us a few

rows of sample data (just the minimum number of fields to illustrate the
problem), the query you are currently using to search the data, the
incorrect result you are getting, and the result you want to get, we would
be better placed to help you.

its really easy

id,category(number),pname(text),sdescription(text) ,bulls(memo),ldescription(
memo),width(number),height(number)
mark

[Bob Barrows]

mark | r wrote:

we have a MSAccess database of products with titles, short
descriptions, long descriotions, bulletpoints etc contained for each
product.

we currently search the database looking for the target keyphrase
within the fields, but this doesnt give any accurate results as for
example a product that is compativle with "widget 1" is shown before
"widget 1"

anyone know of a process that will give us better, more relevant
search results? Sorry. Can't help without more details. Perhaps if you showed us a
few rows of sample data (just the minimum number of fields to
illustrate the problem), the query you are currently using to search
the data, the incorrect result you are getting, and the result you
want to get, we would be better placed to help you.

its really easy

id,category(number),pname(text),sdescription(text) ,bulls(memo),ldescription( memo),width(number),height(number)
mark

How does this help? Please reread my request.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"