-
How would I write this query?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|