N
NoviceAccessUser-Melanie
I have the following expression in a report in Access:
=Sum(NZ((IIf([Ind]="Actual-LIHTC",[1],0))+(IIf([Ind]="Actual-HTC",[1],0)))
-(IIf([Ind]="Original Proforma-LIHTC",[1],0)+(IIf([Ind]="Original
Proforma-HTC",[1],0))))
/NZ(IIf([Ind]="Original Proforma-LIHTC",[1],0))
I used Nz hoping to eliminate problems if either divisor or dividend is
zero. Can someone please tell me what I'm missing in this statement?
Thank you for your time.
=Sum(NZ((IIf([Ind]="Actual-LIHTC",[1],0))+(IIf([Ind]="Actual-HTC",[1],0)))
-(IIf([Ind]="Original Proforma-LIHTC",[1],0)+(IIf([Ind]="Original
Proforma-HTC",[1],0))))
/NZ(IIf([Ind]="Original Proforma-LIHTC",[1],0))
I used Nz hoping to eliminate problems if either divisor or dividend is
zero. Can someone please tell me what I'm missing in this statement?
Thank you for your time.