Can Someone Help. Its Wildcard?

[burton]

hi all.
i have a database that someone loans out garden tools from.
i need to search for a part of a field. because when i search for something at the moment you have to enter the full path.
could someone please tell me how to set up a wild card search. what i can gather this is a search that returns a parial match.

the form i will need to do this on will have the fields:
Id number
Item Name
Amount Per Day.

i want to search on the item name field.

e.g. Bow saw. i could type bow. and bow saw would come up and so would bow blade.

if someone knows how to do this could they tel me how to do it please. in stages if it is complicated

 

[Mile-O]

Basically, you'll be using the Like operator with the wildcard (*) on either side of the field.

i.e Like "*" & [Item Name] & "*"

 

[crosmill]

There a few methods but check the help files in access for full documantaion.

Basically you just put and * at the end, so bow* will find bow with any letters after it *bow* will find bow any where in the string b[n-p]w will find bow etc...

 

[Vassago]

Here is a sample of a multiple keyword search given to me. I don't remember who gave it to me anymore.