BAQ With a Description Criteria


I have a BAQ where I need to limit the results to ones that only have the term “Compr” in them. Now, the description itself is going to have more in it than that, so it can’t JUST be the term “Compr”. I attempted this via specified constant but it didn’t return anything.

I would like some help, please.

Thank you!
CompressorSerialNums1.baq (19.4 KB)

Hi Michele, you will want to use the ‘LIKE’ criteria.

Add a criteria to your table or subquery, where Description is ‘LIKE’ the value ‘%compr%’. % is a wildcard symbol, so if your value begins and ends with %, it will find where ‘compr’ exists anywhere in the description.


Thank you that worked!