Invalid bracketing problem 1

[NeilT123]

This query has stopped working. I get the message "Invalid bracketing" but I am not sure which bracketing is invalid. Can anyone help please

SELECT [FieldCode], Sum(Effect) AS SumOfEffect, Yr
FROM [SELECT [FieldCode],NYr0 as Effect,CInt([OM Application Year]) As Yr FROM qry2rptA1
UNION ALL SELECT [FieldCode],NYr1,CInt([OM Application Year]+1) FROM qry2rptA1
UNION ALL SELECT [FieldCode],Nyr2,CInt([OM Application Year]+2) FROM qry2rptA1
]. AS U
GROUP BY [FieldCode], Yr;

Thanks in advance

 

[PHV]

SELECT [FieldCode], Sum(Effect) AS SumOfEffect, Yr
FROM [!]([/!]SELECT [FieldCode],NYr0 as Effect,CInt([OM Application Year]) As Yr FROM qry2rptA1
UNION ALL SELECT [FieldCode],NYr1,CInt([OM Application Year]+1) FROM qry2rptA1
UNION ALL SELECT [FieldCode],Nyr2,CInt([OM Application Year]+2) FROM qry2rptA1
[!])[/!] AS U
GROUP BY [FieldCode], Yr

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[NeilT123]

Thanks PHV for the prompt and correct response. The query seems to have chaged when I tried to use object dependencies