>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?
George
Ubi caritas et amor, deus ibi est