Hi Richard

I have been thinking about search criteria today.
I have completed my Calendar project
Recurring dates are added on the fly. So you only have to add a birthdate once.
I created another form to add school holidays and public holdays they are not recurring like easter ect.
So another interesting project will be welcome.

I had not thought much about searching however I would be interested in the following
When I type a search criteria in Winamp it gives me exact matches,fields where all the words are contained in the field(s)
and also where some of the words are found, sometimes inside other words.
I think you would need to display best results or click more to get similar or containing matches.
I think Google seperates each word when searching. If you get several matches with the same ID then you have a better match.
I would be interested in knowing how this is done.

I may spend some time thinking about how I would do this myself.
So your Multi Field search may be the answer.
Anyway off the top of my head that's what would be of interest me.

Regards Alan Hill  

---

Reply from Richard Rost:

Hmmm... I don't know if I would go as far as a Google-like search, where you can type in multiple search terms in one box and have the system pull them apart and look for each term separately. That WOULD be cool... but I don't know if it's necessary for an Access database. I like it though, and if this seminar doesn't take TOO much time, I could certainly throw it in - at least separate a search phrase into words, delimited by spaces. Does anyone else have any thoughts on this?