2008-03-26, 18:45 #1
- Join Date
- Jan 2001
- Manchester, Gtr Manchester, England
- Thanked 0 Times in 0 Posts
user 'Keyword' search functionality - how? (2000/XP)
The purpose is to construct a where clause to limit records returned by a query.
Here's what I'm thinking.
A memo field to hold the keywords.
A (lookup) table of keywords.
To maintain control/ quality of entry the user picks keywords from the list (can be multi-select)
The user can add to the list.
Not sure how a search would work
Free typing? sounds nasty
Pick from a list
How would the sql statement be constructed? - I assume I'd need wildcards
Will this work on the memo field?
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2008-03-26, 19:14 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts