Looking for help?
Table of Contents
All Topics
Print

chakka no. not displayed in report ‘chaka wise finished item’

SELECT ChakkaStk_Final.strItemName AS strItem, ChakkaStk_Final.strChakkaNo, ChakkaStk_Final.numOpeningQty, ChakkaStk_Final.numNikasiQty, ChakkaStk_Final.numQtySold, ChakkaStk_Final.numRorWaste, ChakkaStk_Final.numIssue, ChakkaStk_Final.numBalance
FROM ChakkaStk_Final INNER JOIN ChakkeWiseStkTotals ON ChakkaStk_Final.strItemName=ChakkeWiseStkTotals.strItemName
ORDER BY ChakkaStk_Final.strItemName & ” – ” & [numTotal], ChakkaStk_Final.strChakkaNo;