Are you clicking on the SUM button under calculations? If you are, option 2 below should give a total of the P_S_C fields being cool... If there is a chance that there are nulls in the field, you might want to say something like:
IIF(INLIST(nvl(mastertemp.p_s_c, "~"),"P","S","C"),1,0)
>George, Ken
>
>
>This is the code I've tried so far, to no avail.
>
>
>1.IIF(NOT ISNULL(mastertemp.p_s_c) AND NOT EMPTY(mastertemp.p_s_c), 1, 0)
>
>2. IIF(INLIST(mastertemp.p_s_c,"P","S","C"),1,0)
>
>3. IIF(mastertemp.p_s_c,"P","S","C"),1,0)
>
>4. mpaid + msyn + mcomp
>where:
>mpaid = iif(mastertemp.p_s_c = "P",1,0)
>msyn = iif(mastertemp.p_s_c = "S",1,0)
>mcomp = iif(mastertemp.p_s_c = "C",1,0)
>
>
>I suppose I could code this prior to getting to the report writer but I wanted to try to do it within the report write itself.
>
>Maybe it's not possible?
>
>Jim
--Todd Sherman
-Wake Up! Smell the Coffee!