It comes from one table called Inventory... there is a [Part Num] field. There is a field called [Cycle Count] which could have a valus from 1 to 3. And there is a field called [Cycle Quantity]. The Keys r Part Num and Cycle Count. 3 counts can be down on one part. I have to pull from lets say Cycle Count 2 all Part Nums with different values of Cycle Quantity than fry Cycle Count 1.

How do I do this from a query that doesn't used Delcared variable. I need to be able to run this query in VB basically.