Access Query Help

[cirix20]

I have a very large Table with inventory adjustments by location ID



Table set up example is

Location_ID, Date, Item_Number, Item_Desc, Adjustment_Code, QTY, Dollars

What i am needing to do is run a query to see if any of the Item numbers in the table that were adjusted out of inventory (Negative QTY), were later Adjusted back into Inventory (Positive QTY).

Im trying to see if they are taking items out of inventory as an "OOS" Adjustment Code and Later Adjusting it back in as a "CC" Code or other code

[June7]

For a start, consider:

SELECT * FROM table WHERE Item_Number IN (SELECT Item_Number FROM table WHERE Qty <0) ORDER BY Item_Number, [Date];

[ssanfu]

@cirix20 - be aware that "Date" is a reserved word (and a built in function) in Access and shouldn't be used as an object name. Better might be "TransactionDate" or "TransDate".