Several Query Questions

[Kathleen]

Hello forum,
I'm wondering if someone can validate whether or not I can
do this.. I've built a database that houses potential
candidate information based on incoming resumes that we
receive.

Can I:

1) Write a query that searches for keywords that reside in
a memo field, in which the keywords are separated by
commas? For example, there would be a Skills field on the
form which is a memo field. This field would contain
multiple words, separated by commas.

2) Write the above query and allow users to input their
own search criteria via a form? For example, I would
build a form with fields for the input of the search
criteria, including a search button that would execute the
query?

Any direction is greatly appreciated...

 

[Joe Fallon]

Yes it can be done.

But you need to supply more details.

What does this mean:
talented, good-looking, rich, sexy

No - I am not describing myself. <g>

Does it mean: (any word matched is a "hit")
WHERE SomeField Like "*talented*"
OR SomeField Like "*good-looking*"
OR SomeField Like "*rich*"
OR SomeField Like "*sexy*"


or does it mean: (all fields must match for a "hit")
WHERE SomeField Like "*talented*"
AND SomeField Like "*good-looking*"
AND SomeField Like "*rich*"
AND SomeField Like "*sexy*"

Or some combination which the user can define?

 

[Kathleen]

Thanks for your response... I'd like ultimately to
build something where the user can define AND or OR. But
our needs will 99% percent of the time require being able
to search multiple fields using the AND operator. (all
fields must match for a "hit")

Will this approach work with a memo field in Access, where
words are separated by commas?

thanks again..

 

[Joe Fallon]

User choice of AND OR can get complicated too!
What does this mean:

A OR B AND C

They need parentheses if you they user means something other than the
default!
Is it:
(A OR B) AND C

or

A OR (B AND C)

The basic idea will work fine. And it does work with memo fields.
In fact I have a small app that Tony Toews threw together for "common
responses to common questions" which does just that. I am using it right
now!