Reserved error(-3304); there is no message for this error - Access SQL -


i writing sql query access 2010 database. when attempt run it, error appears:

reserved error (-3304); there no message error.

what causing error?

my sql:

 select [cams tnep final].[date entered]     ,[cam issues].department     ,[cam issues].equipment     ,[cam issues].[operation issues]     ,sum([cam issues].downtime) sumofdowntime     ,iif([cam crew] = '3', 'c-crew', iif([cam crew] = '2', 'b-crew', 'a-crew')) crew [cams tnep final] inner join [cam issues] on [cams tnep final].[cam id] = [cam issues].[cam id] group [cams tnep final].[date entered]     ,[cam issues].department     ,[cam issues].equipment     ,[cam issues].[operation issues]     ,iif([cam crew] = '3', 'c-crew', iif([cam crew] = '2', 'b-crew', 'a-crew')) having (         (             ([cams tnep final].[date entered]) >= #8 / 1 / 2014 #             , ([cams tnep final].[date entered]) <= #8 / 1 / 2014 #             )         , (             ([cam issues].department) in (                 '9230-r'                 ,'9230-f'                 )             )         , ((iif([cam crew] = '3', 'c-crew', iif([cam crew] = '2', 'b-crew', 'a-crew'))) iif('all' = 'all', '*-crew', 'all'))         ) order [cam issues].department     ,[cam issues].equipment; 


Comments