Narrowing down report selection (statement?)

[aj3221]

I am running a report on customers who buy broken case products. I have two fields that give me what I need.

Our U/M and the Customers U/M. If the 2 equal then I don't want to see it on the report.

Example:

I wouldn't want to see this (because we sell in cs and they buy in cs):
Cust# Item# Desc Qty Ship Our U/M Cust U/M
001234 SLS123 Straws 10 CS CS

I would want to see this:
Cust# Item# Desc Qty Ship Our U/M Cust U/M
001234 SLS123 Straws 5 CS BX

I don't know how to say to not pull the same u/m only ones that don't match.

 

[Turkbear]

Hi,
Use a record selection formula something like this:

{Our U/M} <> {Cust U/M}

To Paraphrase:"The Help you get is proportional to the Help you give.."