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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bibliography key words 1
Word VBA for deleting Selected Row 0
Search for words in a record 2
Query to duplicate a record with one field updated 0
Itereate cross tab query over another query 0
Retrieving records with a query by form. 3
Search for a word in a memo field ? 3
Count text values in a Access Field 0

Back
Top