Big query help needed

S

Savage

Right some background infomation.

I am creating a infopath search engine to look for data out of a access
database.
I need a query to look up the description column in a suppliers database. I
need the query to allow the user to type in part or incomplete words and for
the query to produce the results with the closest matches.

Does anyone have any advice
 
M

Michel Walsh

Closest match like Google/ Live Search ? There is no such thing right out of
the box, with Access, but if your query runs under Access, and if you have
some idea of your own about how to write code that will do such thing, you
can define your own public VBA function inside a standard module and then,
use that function within your Access query in an ORDER BY clause, by
example. MS SQL Server has some capabilities (Full Text Searching), although
I am not sure if it is available for MS SQL Server Express.


Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query very slow 5
query too slow 1
Query Help Needed 8
Searching for specific word in query 3
Help Needed on Complicated Query 1
Convert text string to number in a query 3
Auto update query 5
Query shows no results when using 2 tables with multiple relations 3

Top