multiple keyword search

[Real Wally]

Could someone please show me how I include a search option based on multiple keywords. Now that my DB is expanding I get too many hits on a single term. I'd like to be able to type a few terms with a space in between them and perform a search on those keywords. I haven't got a clue where to start myself. Help would be greatly appreciated.
Thanks,

Wally

 

[Jack Cowley]

This article should answer your question.

hth,
Jack

 

[Real Wally]

Thanks Jack.

I'll have a good look at that article.
I use Access97 but assume that won't make a huge difference.

Have a good weekend,

Walter

 

[Jack Cowley]

You are welcome. I assumed that you are searching for 'keywords' in a single field and not across multiple fields. If you want to search multiple fields then you will want to use a different approach. If that is what you want to do then take a look here.

Good luck with your project....

Jack

 

[Real Wally]

Yes! That seems to be the one
I'd like to be able to search multiple fields (text, number and date) from multiple tables so I guess your last pointer is the one I was looking for.

Thanks again Jack and I'll start working on it and hope to get it going soon.

Walter

 

[Jack Cowley]

Walter -

You are welcome and good luck with your project.

Jack