How I get right value by multiple iif function

[afeef]

I have query field named SBDR. in this field I have written a formula same as

IIf(Left([CATEGORY],6)="SAVING",1 And IIf([DrAMOUNT]>0,1,0))

. For true value it returning -1and for false blank but i need 1. Another problem is I have more field like SBDR. such as SBCR, CDDR, CDCR. when I use [SBDR]+[SBCR]+[CDDR]+[CDCR] formula in another field , it returns blank value.



What can I do now?

note: DrAmount is Number field

[ranman256]

any field that is null will result in null (in any math op)
so convert if they may be null

NZ([SBDR])+NZ([SBCR])+NZ([CDDR])+NZ([CDCR])

and you prob. want: IIf(Left([CATEGORY],6)="SAVING", IIf(NZ([DrAMOUNT])>0,1,0),0)