Todd,

I thought I had tried the SUM button before and was getting some ungodly high numbers, but with option 1. clicking sum works.

I'm really not sure what I was doing wrong but the problem has been corrected, thanks to all the help I've received.

Thanks everyone,

Jim

>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