Hi
I am trying to replace null values on a form with Zeros.
I have placed the following in the control source of the field but keep getting a #Name? error.
=IIf(IsNull([QrySalesTYEvents_Crosstab].[Jan]),0,([QrySalesTYEvents_Crosstab].[Jan]))
Could someone please point me in the right direction with this?
Many thanks
I am trying to replace null values on a form with Zeros.
I have placed the following in the control source of the field but keep getting a #Name? error.
=IIf(IsNull([QrySalesTYEvents_Crosstab].[Jan]),0,([QrySalesTYEvents_Crosstab].[Jan]))
Could someone please point me in the right direction with this?
Many thanks