Filter records

[Guest]

I have created a query and would like to filter the information generated by
the query. The field I want to filter contains a lot of information. I want
to filter for records containing the word "closed" which depending upon the
record can be the first word, could be somewhere in the middle or at the very
end of the information contained in the field.

How do I filter for that word?

Thanks so much.

 

[fredg]

I have created a query and would like to filter the information generated by
the query. The field I want to filter contains a lot of information. I want
to filter for records containing the word "closed" which depending upon the
record can be the first word, could be somewhere in the middle or at the very
end of the information contained in the field.

How do I filter for that word?

Thanks so much.

Specifically the word 'closed'?
Like "*closed*"

If you wish to vary the word to filter on:
Like "*" & [What word] & "*"
You'll be prompted to enter the word.

 

[Guest]

Well that was way too simple, now wasn't it? Missed the astericks - have the
quotes in place. Thank you so much!

I have created a query and would like to filter the information generated by
the query. The field I want to filter contains a lot of information. I want
to filter for records containing the word "closed" which depending upon the
record can be the first word, could be somewhere in the middle or at the very
end of the information contained in the field.

How do I filter for that word?

Thanks so much.

Specifically the word 'closed'?
Like "*closed*"

If you wish to vary the word to filter on:
Like "*" & [What word] & "*"
You'll be prompted to enter the word.