>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".


Hi Jim,

How about:

IIF(NOT ISNULL(mastertemp.p_s_c) AND NOT EMPTY(mastertemp.p_s_c), 1, 0)

instead?