invalid bracketing of name error

[Guest]

In creating the following in SQL I am getting the following error "invalid
bracketing of name"... As I look at this

SELECT [Beginning Transaction Date] AS Expr2, [Ending Transaction Date] AS
Expr3, [Manual check].[PaygroupLookup] AS [Business unit],
Sum(IIf([Compliance policies]="No",1,0)) AS [Compliance with Pay
Policies], Sum(IIf([Compliance pay practices]="No",1,0)) AS [Compliance with
Pay Practices], Sum(IIf([Authorization]="No",1,0)) AS [No
Authorization], Sum(IIf([Valid employee]="No",1,0)) AS [No Valid employee],

 

[Guest]

You need to post the rest of the SQL.