Hi Ken,

Thanks for the idea, I tried it out, but it's still counting the blanks.

I tried this "iif(mastertemp.p_s_c=" ",0,1)", but it doesn't work either, I'm still getting all the records added, not just the ones with either "P","S", or "C".


Jim Harvey
jharvey@netrax.net


>In your Totals field in the group footer, the expression should be :
>
>"IIF(INLIST(mastertemp.p_s_c,"P","S","C"),1,0)"
>
>This will count the total for the categories with have entries in the other columns..