hello,

I need my parameter query to find to closest match to what my user enters... similar to what google does.

e.g the user types in "coffee" and the query brings up "coffee and walnut"...

I dont know whether this is even possible. I'd much appreciate any help you are able to give me as my knowledge of databases is very limited.

Thanks :)

Well, you can use this in the query's criteria:

Like "*" & [Enter Parameter] & "*"

or if you use a form to input the value

Like "*" & [Forms]![YourFormNameHere]![YourTextboxNameHere] & "*"

THANK YOU SOOOOOO MUCH!!

Did exactly want I needed it to do first time round

:D:):D

Glad we could help.

Oh, and by the way, I forgot to say:

http://downloads.btabdevelopment.com/screenshots/welcometoawf.png