Search results

  1. M

    Suppressing multiple rows based on a field value in one row

    Thanks! I’ll try it.
  2. M

    Suppressing multiple rows based on a field value in one row

    Thanks for your help! I’m setting this up for someone who is not Access savvy, so I think I will just have him run 2 queries: 1 a query that creates a table of distinct order numbers that have at least one zero qty, then a second query that gives the information needed, but removes the order...
  3. M

    Suppressing multiple rows based on a field value in one row

    That is a great idea!! i will try that. Thanks so much!
  4. M

    Suppressing multiple rows based on a field value in one row

    Won’t that just remove the rows with 0 And leave the rows where qty is greater than 0? If anyone of the qtys is 0 I need all the rows for that order number to be removed.
  5. M

    Suppressing multiple rows based on a field value in one row

    Trying to filter them using a query.
  6. M

    Suppressing multiple rows based on a field value in one row

    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...
Back
Top Bottom