This query runs on my pc but not on my laptop

  • Thread starter Thread starter GWB
  • Start date Start date
G

GWB

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];


Failure message is: invalid bracketing of name 'SELECT........
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top