My query is run to cursor and then report populated from cursor. I
pass in fields SFAMOUNT (numeric) and SFPD (date). I need the SUM of
SFAMOUNT where SFPD is null and also SUM of SFAMOUNT where SFPD is not
null. How can I state that in a report variable? Should be easy, but
I'm saying something wrong.

Thanks.

Monica

Monicate,
Is the Date field really null or simply "empty"?
One expression: sum(iif(isnull(SFPD),0,SFAMOUNT))
The other: sum(iif(isnull(SFPD),SFAMOUNT,0))
OR
One expression: sum(iif(empty(SFPD),0,SFAMOUNT))
The other: sum(iif(empty(SFPD),SFAMOUNT,0))

Rick

"Monica J. Braverman" <monica (AT) datashark (DOT) net> wrote