Hello - my question is why does this query run fine:
Code:
SELECT sum(AvgOfCurrentSteamFlow)
FROM [SELECT dbo_Boiler_Steam_Production.ReadingDate AS Expr1, Hour([ReadingTime]) AS Expr3, Avg(dbo_Boiler_Steam_Production.CurrentSteamFlow) AS AvgOfCurrentSteamFlow
FROM dbo_Boiler_Steam_Production
GROUP BY dbo_Boiler_Steam_Production.ReadingDate, Hour([ReadingTime])
HAVING (((Year([ReadingDate]))=[Select Year]))]. AS [%$##@_Alias];
But this gives me a bracketing error:
Code:
SELECT sum(AvgOfCurrentSteamFlow)
FROM [SELECT dbo_PWL_Boiler_Steam_Production.ReadingDate AS Expr1, Hour([ReadingTime]) AS Expr3, Avg(dbo_PWL_Boiler_Steam_Production.CurrentSteamFlow) AS AvgOfCurrentSteamFlow
FROM dbo_PWL_Boiler_Steam_Production
GROUP BY dbo_PWL_Boiler_Steam_Production.ReadingDate, Hour([ReadingTime])
HAVING (((Year([ReadingDate]))=[Select Year]))]. AS [%$##@_Alias];
Thanks for any help!