>SELECT sum(IIF(rrspcont = 0,1,0)) as rrsp0,
>       sum(IIF(rrspcont = 1,1,0)) as rrsp1, and so fourth
>FROM...

>Can I group the IIF in another IIF and still keep the same results?
>(sum(IIF(rrspcont = 0,1, IIF(...) without changing the variable
>name to store the result?

You mean, like:

SELECT SUM(IIF(rrspCont = 0, 1, IIF(rrspCont = 1, 1, 0))) AS rrspSum ;
FROM...

That works, but I'm not sure if that's what you're trying to do....