Query on text

A

ACDenver

I am seeking an answer on how to query a text string when the last word ends
with the seven character word "Minimum". I run a local report, and we have
various text string lengths that end with the word "Minimum", and I am trying
to query on these exception items. Help is appreciated. Thanks.
 
D

David S via AccessMonster.com

ACDenver said:
I am seeking an answer on how to query a text string when the last word ends
with the seven character word "Minimum". I run a local report, and we have
various text string lengths that end with the word "Minimum", and I am trying
to query on these exception items. Help is appreciated. Thanks.
Click to expand...

Try using a query with criteria on this field of: Like "*Minimum"

Alternatively, you could create a calculated field Right(field, 7) and use a
criteria of "Minimum"
 
Top