I have a Product table which captures all incoming stock
I have a Outgoing table which captures all outgoing stock
I have created a query from the product and outgoing tables and in a colum by itself have totalled the amount of stock per product however, what I am needing to see is
1. a report that collates all specific type of stock for example Passenger and includes any outgoing.
I have so far got this far as per below, what I am finding is info is now being duplicated and showing multiple entries for any one particular item...i would appreciate help on this one
Expand|Select|Wrap|Line Numbers
- SELECT Products.[Product Name]
- ,OutgoingTBL.Type
- ,OutgoingTBL.Size
- ,Products.QTY
- ,OutgoingTBL.[Qty Out]
- ,Sum([products]![Qty]-nz([Qty Out],0)) AS [Current Tyre Type in stock]
- FROM Products INNER JOIN OutgoingTBL ON Products.Type = OutgoingTBL.Type
- GROUP BY Products.[Product Name]
- ,OutgoingTBL.Type
- ,OutgoingTBL.Size
- ,Products.QTY
- ,OutgoingTBL.[Qty Out]
- HAVING (((OutgoingTBL.Type) Like "*" & [Enter Type Allterrain 4WD, Light Truck, MUDTerrain, Passenger, SUV, Tube] & "*"));