Keyword Search

[Saxman]

I need to do a 'keyword' search for users of my database.

Searches need to be restricted to single words and no wild cards will be
allowed.

I have created a new table with a list of keywords.

What is the best way to achieve this? There does not appear to be an
input mask for this kind of search. Do I need to apply validation rules
and if so, how?

TIA.

 

[Guest]

Most use wildcards with their keyword inputs but this returns more than what
they want. Example - Mile = Mile, Mileage, Milestone, Smile, etc.

You can have a keyword field and use exact word match without using a
separate table. The data in the table would use a separator like commas.
Example - Milk, Calcium, Vitamin D, Fat, etc.

Your criteria would be like this --
Like "* " & [Enter keyword - exact spelling] & ",*"
This criteria requires there to be a leading space and a trailing comma in
the keyword field.