Query on text

[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.

 

[David S via AccessMonster.com]

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.

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"