Please assist how can we use the case statement with the correct syntax, i've been having problems with reserve word?
strRequest = "Select timevalue(datetime) as [DateTime], " & _
" [case when 0=0 then 1 end] as [aaa] " & _
" From [Mytable$] " & _
" group by timevalue(datetime);"
error returned "no value given for one or more required parameter."