query help

[securityman]

I have a query that filters voided records. If the voided record's "Comment" field has the words "Rejected - over 96,000 lbs.", that record will go into the report that the query feeds. But if someone adds any other words to the comment field after the "rejected...." comment, the record does not appear in the report. How can I get any record that starts with "Rejected- over 96,000 lbs." with any thing after that to appear in the report? Can I use a wild card in the criteria of the query?

 

[Trevor G]

In your query on the comments field criteria try adding this

Like "*Rejected- over 96,000 lbs*"

 

[RichardMGreen]

You should be able to.
You can also use Instr to check if that text appears in the field. If the result is greater than 0 it's in there and should go in the report.

 

[securityman]

Thanks, guys.....I'll try your way Trevor G.
Richard, how would I write the criteria? Instr("Rejected - over 96,000 lbs.")?