Remove line items with matching values in columns

[laniebe]

Hello! I am trying to filter transactions to only show the transactions that made a "quantity change" in the system. My query has the following columns - Item Number, TransQuantity, PrevQuantity, NewQuantity, Warehouse. If the line has the same value in both PrevQuantity, and NewQuantity - I do not want those to show as those were internal moves that did not actually change the quantity with movement in or out of the warehouse.

How can I create a new query that does not show the line items with the matching quantities in the same line. Thank you very much for your help!

[andy49]

In a criteria of prevquantity just add <> newquantity

Is this what you mean?

[laniebe]

I knew it was something so easy!!! I was coming up blank on this one. That works perfect, thank you!