GROUP BY Clause is not required...

SELECT tblBOM_Detail.PRODUCT_CODE AS [Product #],

tblBOM_Detail.PRODUCT_DESCRIPTION AS [Description],

tblBOM_Detail.UOM AS [Unit (kg/mt...)],

...