Hi can anyone help me with the following query it is giving me this error:
"The LEVEL clause includes a reserved word or argument that is misspelled or missing, or the punctuation is incorrect."
here's the query
cheers
"The LEVEL clause includes a reserved word or argument that is misspelled or missing, or the punctuation is incorrect."
here's the query
Code:
SELECT
DateValue([Finished]) AS [Date],
Paintshop_tblProduction.PartNo,
Paintshop_tblProduction.Description,
Sum(Paintshop_tblProduction.[Actual Qty Produced]) AS Total,
Paintshop_tblRoutings.OpDescription,
Paintshop_tblRoutings.Powder_Usage,
(([Powder_Usage]*Sum([Actual Qty Produced]))/1000) AS [Planned Powder Usage (Kg)],
Paintshop_tblRoutings.QtyPerJig,
(Sum([Actual Qty Produced])/[QtyPerJig]) AS [Jigs Painted],
Paintshop_tblRoutings.[Area (m2)] AS [Area per panel (m2)],
Paintshop_tblRoutings.[Wrap Around (%)],
([Area (m2)]*(1+(([Wrap Around (%)]/100))/100)*(Sum([Actual Qty Produced]))) AS [Total Area (m2)],
(Sum([Actual Qty Produced])/[QtyPerJig])*(50/1000) AS [Powder lost to Jigs (Kg)]
FROM Paintshop_tblProduction
LEFT JOIN Paintshop_tblRoutings ON Paintshop_tblProduction.PartNo = Paintshop_tblRoutings.PartNo;
GROUP BY DateValue([Finished]),
Paintshop_tblProduction.PartNo,
Paintshop_tblProduction.Description,
Paintshop_tblRoutings.OpDescription,
Paintshop_tblRoutings.Powder_Usage,
Paintshop_tblRoutings.QtyPerJig,
Paintshop_tblRoutings.[Area (m2)],
Paintshop_tblRoutings.[Wrap Around (%)]
HAVING (((DateValue([Finished])) Between '24/04/2012 00:00:00' And '24/04/2012 23:59:59']));
cheers