IIf (1 Viewer)

[mike60smart]

Hi Everyone

Can anyone see where I am wrong with this IIf statement?

=IIf([TotalC]=0 And [ContractSumtoDate]=0,[RunningTotal]=[OriginalContractSum],IIf([TotalC]=0,[ContractSumToDate],(Nz([ContractSumToDate],0)-Nz([txtT],0))))

Any help appreciated

 

[theDBguy]

Hi Mike. Are you wanting to get a True/False result?

 

[isladogs]

Assuming you are calculating the RunningTotal, then

RunningTotal=IIf([TotalC]=0 And [ContractSumtoDate]=0,
[OriginalContractSum],IIf([TotalC]=0,
[ContractSumToDate],Nz([ContractSumToDate],0)-Nz([txtT],0)))

 

[mike60smart]

Hi Colin

Perfect Thanks very much

 

[isladogs]

You're welcome. An 'inspired' guess on my part.