Problem: The field [PermitTerm] contains nulls. Where the field [PermitTerm] is null, all the queries I try only return nulls.
I need to add PermitTerm to LeaseTerm and get a number answer. I need to change nulls to zeroes so I can use PermitTerm as a number to add to other numbers.
I have tried:
Case 1: A two step problem using the expression [Pt] and [PmtTerm] Returns nulls:
Pt: IIf([PermitTerm]=Null,0,1) Returns 1 and Zeros
PmtTerm: IIf([Pt]=1,[PermitTerm],0)
Case 2: Pt: IIf([PermitTerm]=Null,0,[PermitTerm]) Returns nulls
Case 3: Pt: Nz([PermitTerm]) Returns Nulls
Thank you.
Hefly
I need to add PermitTerm to LeaseTerm and get a number answer. I need to change nulls to zeroes so I can use PermitTerm as a number to add to other numbers.
I have tried:
Case 1: A two step problem using the expression [Pt] and [PmtTerm] Returns nulls:
Pt: IIf([PermitTerm]=Null,0,1) Returns 1 and Zeros
PmtTerm: IIf([Pt]=1,[PermitTerm],0)
Case 2: Pt: IIf([PermitTerm]=Null,0,[PermitTerm]) Returns nulls
Case 3: Pt: Nz([PermitTerm]) Returns Nulls
Thank you.
Hefly