raymond3090
Registered User.
- Local time
- Today, 21:11
- Joined
- Sep 5, 2002
- Messages
- 43
hi there,
I currently have a query that uses fields from a 'Search' form as it's criteria. One of my fields is 'keywords'. In this field, the user types in various keywords that may be used to describe the record.
As it stands now, a user might input: reservoir oil engineering.
What I would like is for this query to return any records with any of these words in keywords field in the underlying table. Currently, this query would only return those records having these keywords in the exact order as what was typed in.
My Where statement for this field is something like:
(Items.Keywords) Like "*" & [Forms]![Search]![txtKeywords] & "*").
I see these fields in on-line databases where the user can type in AND or OR to make their searches do what they want. This would be ideal here, but I have no idea how to do it.
help please!
ray
I currently have a query that uses fields from a 'Search' form as it's criteria. One of my fields is 'keywords'. In this field, the user types in various keywords that may be used to describe the record.
As it stands now, a user might input: reservoir oil engineering.
What I would like is for this query to return any records with any of these words in keywords field in the underlying table. Currently, this query would only return those records having these keywords in the exact order as what was typed in.
My Where statement for this field is something like:
(Items.Keywords) Like "*" & [Forms]![Search]![txtKeywords] & "*").
I see these fields in on-line databases where the user can type in AND or OR to make their searches do what they want. This would be ideal here, but I have no idea how to do it.
help please!
ray
