Search results

  1. S

    Solved Combination Criteria

    Worked perfect. Learned something new today. Thanks a lot.
  2. S

    Solved Combination Criteria

    Can someone please help me on this? In the below screenshot I want the sql qry to return only 'Ord3' Ord1 must be excluded because of 'FC' (easy <> "FC") Ord2 must be excluded because one of those records have 'FC' (struggling) Ord3 must be included since it doesnt have any 'FC' records Right...
  3. S

    Left joint query type mismatch

    Working with two tables - tbl_A_OrdData & tbl_B_ShipData tbl_A have all the orders placed, but tbl_B only have the orders that got shipped. I'm trying to create a query that will show me all orders that got placed for a particular criteria and if the order find a match in tbl_B to give me the...
Top Bottom