Hello, in the following sample data I need to write a query that will NOT include any records that have a TYPE O CLASS A and a TYPE I CLASS A with the same date and same QTY. For Example my data result can not include the 10/22/2005 date.


PART_ID DATE QTY TYPE CLASS
001006 12/12/2001 1 O A
001006 12/12/2001 4 I A
001006 5/21/2005 3 O A
001006 5/21/2005 3 I A
001006 5/22/2005 1 O A
001006 10/22/2005 2 I A
001006 10/22/2005 2 O A
001006 5/1/2006 1 O I
001006 11/18/2006 1 I A
001006 11/18/2006 1 O A
001006 11/18/2006 1 I A
001006 2/26/2007 1 O I

Not like O

in the query criteria

i only need the date excluded if there is an I/A and an O/A with the same date and same qty for any given part number. simply excluding the O's won't help.