Selecting Items to include in report.

[jellybead]

Good Morning All,
I have a questions that I'm not sure how to ask, but will try anyway.
We are using V8.5.

This report includes all part numbers except in the following instance:

When a part number contains the string DATA AND the unit price has dollars, then include on the report.

We have DATA part numbers with unit prices that are zero, which can not be presented on this report, but will be presented on another report.


I am able to filter out the string *DATA, but can't figure out the rest.

Could someone help me out?

Thanks, E

 

[M8KWR]

to filter out the DATA, then you would use

not like *DATA* in the query, if this helps.

But you could use some type of formatting on the report to alter your report if a field contains a certain value, if thats more use to you