New beginner Access user

[wiesem]

Hi, my name is Morne and I am a beginner access user. I live in Bloemfontein, located in South Africa.

 

[Minty]

Hi Morne - Welcome to AWF !

 

[wiesem]

Can anyone maybe help with below?
I have two columns name NRESULT and TRESULT. I want to add one or the other into a new field on a report. The idea is that if the NRESULT is null, then it should use the TRESULT, and the other way around. I created the follow formula: NTResult: IIf(IsNull([NRESULT]),[TRESULT],IIf(IsNull([TRESULT]),[NRESULT],[TRESULT])).
It works well, except if the TRESULT is empty, then it does not use the NRESULT, because of the formula above. It is possible to combined the following two formulas:
IIf(IsNull([NRESULT]),[TRESULT],[NRESULT])
IIf(IsNull([TRESULT]),[NRESULT],TRESULT])

 

[arnelgp]

NTResult: IIf(IsNull([TRESULT]),IIF(ISNULL([NRESULT]), NULL, [NRESULT]), [TRESULT])

 

[arnelgp]

i like your icon, the green thing...