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