Big query help needed

[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

 

[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