Search results

I have a table that contains the fields “order number” and “qty”. There are multiple rows for each order number. How can I suppress all rows for an order number where quantity is 0 on one of the rows? Example: order # 123 has 4 rows. One row has a qty of 1, the second row has a qty of 2, the...