Help on searching using a query

[scoobydoo084]

Hi Guys if you can help me on this that would be brill!! i have a database that manages doucuments in a company, i have serveral queries that run to help the user search, the problem i have got is that they need to supply the exact name of the document, is there a way of searching using keywords. for example: instead of Driving and Road Policy just searching Road and getting the same document cheers in advance

 

[Kryst51]

In the query put "Like [SearchText]" for the field criteria.

 

[scoobydoo084]

cheers for the reply, so for example: "Like [Please Enter Policy Name]"

 

[Kryst51]

yup, although I am not sure that if they mispell something it will find it, for instance if they type "raod" instead of "road", or use "&" when it should be "and".

 

[scoobydoo084]

the misspellign doesnt matter, i just tried it in the critria field im my query and it didnt return any results. i have certificates called CITB Construction Skills so i typed in CITB and it didnt pick up the certificate. (i have 5 databases that managed different types of docs so i may use different examples )

 

[Kryst51]

OK, Try - "=*+[EnterSearchWordHere]+*"

 

[scoobydoo084]

cheers for that but i still have no joy is there anything that might need changing?

 

[Kryst51]

Can you post your db?

 

[Brianwarnock]

Never done it but think the syntax would be
Like "*" & [enter whatever] & "*"


Brian

 

[Kryst51]

That makes sense, I don't use it very often, but I thought I remembered one or the other working.

 

[scoobydoo084]

its too big to post (about 10mb), sorry. any other ideas,

 

[Kryst51]

its too big to post (about 10mb), sorry. any other ideas,

Try Brian's idea

 

[scoobydoo084]

IT WORKED thanks so much both of you for your help. much appreciated and im sure the staff here will be happy too (Y)

 

[raskew]

Hi -

Take a look at the application at Post #7 of this thread. It allows the operator to search (anywhere within field) on keystroke by keystroke basis. With each keystroke, the app drills down to possibly applicable records.

Bob