mike60smart
Registered User.
- Local time
- Today, 00:50
- Joined
- Aug 6, 2017
- Messages
- 1,904
Hi Everyone
Can anyone see where I am wrong with this IIf statement?
Any help appreciated
Can anyone see where I am wrong with this IIf statement?
Code:
=IIf([TotalC]=0 And [ContractSumtoDate]=0,[RunningTotal]=[OriginalContractSum],IIf([TotalC]=0,[ContractSumToDate],(Nz([ContractSumToDate],0)-Nz([txtT],0))))
Any help appreciated