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?
Subscribe to our Windows Secrets Newsletter - It's Free!
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