SQL Query

SELECT INPUT.code, [INPUT]![package]-[sold]![quantity package] AS stock_package, [INPUT]![peice]-[sold]![quantity peice] AS [peice balance], INPUT.price, INPUT.[price OF package], INPUT.peice, sellqury.[quantity peice]
INTO myTempTable
FROM ([INPUT] INNER JOIN sellqury ON INPUT.code = sellqury.code) INNER JOIN sold ON INPUT.code = sold.Code
GROUP BY INPUT.code, [INPUT]![package]-[sold]![quantity package], [INPUT]![peice]-[sold]![quantity peice], INPUT.price, INPUT.[price OF package], INPUT.peice, sellqury.[quantity peice];
SELECT
 SUM([quantity peice]) AS [quantity peice],
'ahmed101' AS [code]
FROM myTempTable WHERE code = 'ahmed101';