Miles

SELECT "1" AS ID, "Issues" AS [Action], [tab_STK_RAW STOCK].[Stock Reference], [tab_STK_RAW STOCK].[Short Description], [tab_STK_RAW STOCK].[Opening Balance], [tab_STK_RAW STOCK ISSUES].DateStamp, [tab_WRK_WORKS ORDERS].[Order No] AS [Works Order No], [tab_STK_RAW STOCK ISSUES].[Cutting Instruction No], [tab_WRK_CUTTING INSTRUCTIONS].[FG Stock Reference], [tab_STK_RAW STOCK ISSUES].[Quantity Issued], -[tab_STK_RAW STOCK ISSUES].[Quantity Issued] AS Quantity, "" AS Description, [OPENING BALANCE]-[ISSUES]+[RECEIPTS]+[ADJUSTMENT] AS INSTOCKFROM ([tab_STK_RAW STOCK] INNER JOIN ([tab_STK_RAW STOCK ISSUES] INNER JOIN [tab_WRK_CUTTING INSTRUCTIONS] ON [tab_STK_RAW STOCK ISSUES].[Cutting Instruction No] = [tab_WRK_CUTTING INSTRUCTIONS].[Cutting Order No]) ON [tab_STK_RAW STOCK].[Stock Reference] = [tab_STK_RAW STOCK ISSUES].[Stock Reference]) INNER JOIN [tab_WRK_WORKS ORDERS] ON [tab_STK_RAW STOCK ISSUES].[Works Order No] = [tab_WRK_WORKS ORDERS].[Works Order No];UNIONSELECT "3" as ID, "Adjustment" AS [Action], [tab_STK_RAW STOCK].[Stock Reference], [tab_STK_RAW STOCK].[Short Description], [tab_STK_RAW STOCK].[Opening Balance], [tab_STK_RAW STOCK ADJUSTMENTS].DateStamp, "N/A" AS [Works Order No], "N/A" AS [Cutting Instruction No], "N/A" AS [FG Stock Reference], [tab_STK_RAW STOCK ADJUSTMENTS].[Quantity Adjusted] AS [Quantity Issued], [tab_STK_RAW STOCK ADJUSTMENTS].[Quantity Adjusted] AS [Quantity],[Notes] AS Description, [OPENING BALANCE]-[ISSUES]+[RECEIPTS]+[ADJUSTMENT] AS INSTOCKFROM [tab_STK_RAW STOCK] INNER JOIN [tab_STK_RAW STOCK ADJUSTMENTS] ON [tab_STK_RAW STOCK].[Stock Reference] = [tab_STK_RAW STOCK ADJUSTMENTS].[Stock Reference];UNION SELECT "2" AS ID, "Receipt" AS [Action], [tab_STK_RAW STOCK].[Stock Reference], [tab_STK_RAW STOCK].[Short Description], [tab_STK_RAW STOCK].[Opening Balance], [tab_STK_RAW STOCK RECEIPTS].DateStamp, "PO : " & [Purchase Order No] & " GRN : " & [Purchase Order Desc] AS [Works Order No], "N/A" AS [Cutting Instruction No], "N/A" AS [FG Stock Reference], [tab_STK_RAW STOCK RECEIPTS].[Quantity Received] AS [Quantity Issued], [tab_STK_RAW STOCK RECEIPTS].[Quantity Received] AS Quantity, "" AS Description, [OPENING BALANCE]-[ISSUES]+[RECEIPTS]+[ADJUSTMENT] AS INSTOCKFROM ([tab_STK_RAW STOCK] RIGHT JOIN [tab_STK_RAW STOCK RECEIPTS] ON [tab_STK_RAW STOCK].[Stock Reference] = [tab_STK_RAW STOCK RECEIPTS].[Stock Reference]) INNER JOIN qry_stk_grn_details ON [tab_STK_RAW STOCK RECEIPTS].[GRN Item No] = qry_stk_grn_details.Item_ID;