I am currently trying to correct a database that is not functioning properly. I will post a snip of the error message and the code below.
[SELECT tblCrushingData.Date, Sum(IIf([CrushingProd]>0,([CrushingProd]/2000)/Sum([Uptime]),0)) AS TPH, 1 AS Expr1, 0.55 AS Expr2, tblCrushingData.Operator, tblCrushingData.Shift, tblCrushingData.[303 Start], tblCrushingData.[303 Ending], tblCrushingData.[Planned RnTm], tblCrushingData.[Planned DT], tblCrushingData.[Unplanned DT], tblCrushingData.[Uptime], tblCrushingData.[Comments1], tblCrushingData.[OEE Comments]
FROM tblCrushingData INNER JOIN qryDayWT ON tblCrushingData.Date = qryDayWT.PrDate
GROUP BY tblCrushingData.Date, 1, 0.55, tblCrushingData.Operator, tblCrushingData.Shift, tblCrushingData.[303 Start], tblCrushingData.[303 Ending], tblCrushingData.[Planned RnTm], tblCrushingData.[Planned DT], tblCrushingData.[Unplanned DT], tblCrushingData.Uptime, tblCrushingData.Comments1, tblCrushingData.[OEE Comments], tblCrushingData.[OEE Comments]
HAVING (((tblCrushingData.Date)>Now()-45))
ORDER BY tblCrushingData.Date DESC;]