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
Post a Comment