Results 1 to 2 of 2
Thread: Keyword parameter (Access 2000)
2005-07-16, 08:16 #1
- Join Date
- Feb 2001
- Thanked 2 Times in 2 Posts
Keyword parameter (Access 2000)
I have a query in which I want to include a parameter prompt so that the user can specify a keyword that the retrieved records must contain in either of two Keyword fields that contain strings of keywords.
1. I tried creating a field Keywords: [Keywords1] & [Keywords2] with the criterion Like "*" & [Enter Keyword (Enter=All):] & "*", but this retrieves no records, whether the keyword is null or not. How can I correct this?
2. Is it possible to go beyond this so that the user could enter multiple keywords and retrieve records where any of these words occurs in any order in either of the two Keyword fields, e.g., where [Keywords1] contains "one, two, three" and [Keywords2] contains "four, five, six" and the user enters "five one", or "five seven", or "fiv thre"?
2005-07-16, 14:44 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: Keyword parameter (Access 2000)
You would have to do this with Or conditions: Like "*" & [Enter Keyword1] & "*" Or Like "*" & [Enter Keyword2] & "*"Charlotte