>Paul,
>
>You're very close. Count simply gives you the number of records it encounters. What you put inside the parenthises may affect the performance but it certainly won't affect the result.
>
>Try SUM(IIF(ISNULL(Table1.Rnum) > 0,1,0)) AS RnumTotal.
>
That almost worked. SUM(IIF(ISNULL(Table1.Rnum),1,0)) AS RnumTotal worked better. Thanks for the help.