Problems with queries

[Guest]

I'm trying to use a parameter query to show records which contain a specific
keyword - When I run the parameter query no records are selected. The field
which I am querying is a memo field which contains a list of keywords. Could
my problem lie with the format of the text in the memo field, (separated by
spaces, not commas) or should I try a different type of query?

 

[Guest]

It would be easier if you were more specific otherwise you normally get
questions like:

What is the SQL of your query?
If you are using the QBE grid, what have you put in the criteria section?
Have you used wild cards?
Have you used = or LIKE?

But on the information you have provided I suggest you try something like
this in the criteria section of the QBE grid of the field you want to search

Like "*" & [enter keyword to search] & "*"

 

[Guest]

Dylan

Thanks - that works perfectly!

My problem was that I wasn't sure where to put the wildcards!

Susy

It would be easier if you were more specific otherwise you normally get
questions like:

What is the SQL of your query?
If you are using the QBE grid, what have you put in the criteria section?
Have you used wild cards?
Have you used = or LIKE?

But on the information you have provided I suggest you try something like
this in the criteria section of the QBE grid of the field you want to search

Like "*" & [enter keyword to search] & "*"

--
I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia

I'm trying to use a parameter query to show records which contain a specific
keyword - When I run the parameter query no records are selected. The field
which I am querying is a memo field which contains a list of keywords. Could
my problem lie with the format of the text in the memo field, (separated by
spaces, not commas) or should I try a different type of query?