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