Searching for records with one or more key words

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to develop a query or VBA code (for use in MS Access) to enable user
to locate
records using 1 or more key words. Each record will have (say) 10 key words.

My questions are:

How should I store the key words - each in separate field or in memo field

How do I set up the search?

How do I present results of search - ie a list of records. Some records may
match 1 of the users key words, others may match manyu or all.

Assistance would be much appreciated.
 
They should be in their own related table. You can create a query that
counts the number of matches and presents the results in descending order of
the count field.

HTH;

Amy
 
Back
Top