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