Hi Joro,

Sorry, there's extra comma after Qout. Also, you query doesn't take in account movimento values of 50 and 51. Is it intentional?

>Hi Sergey,
>
>Thank's for your response, i try that with my real table name, like
>

>SELECT ficmolde, ficmater, ;
>    SUM(IIF( movimento <= 49, Quantidade, 0)) AS Qin, ;
>    SUM(IIF( movimento >  51, Quantidade, 0)) AS Qout, ;
>    from ficmvmp ;
>    group by 1,2
>

>and it gives an error to me
>

'command is missing required clause'

>
>Thank's
>
>João