Hi all.
I was wondering if anyone might be able to help me simplify the following that I am using to calculate a value on one of my forms:
All the [txt..Calc] are calcutated text boxes themselves. I guess I am just wondering if there is a simple way to ditch the 'IIf IsNull' segments.
Any help appreciated!
Thanks.
I was wondering if anyone might be able to help me simplify the following that I am using to calculate a value on one of my forms:
Code:
=(Iif (IsNull([txt24Calc]),0,[txt24Calc]))+
(Iif (IsNull([txt27Calc]),0,[txt27Calc]))+
(Iif (IsNull([txt30Calc]),0,[txt30Calc]))+
(Iif (IsNull([txt33Calc]),0,[txt33Calc]))+
(Iif (IsNull([txt36Calc]),0,[txt36Calc]))+
(Iif (IsNull([txt39Calc]),0,[txt39Calc]))+
(Iif (IsNull([txt42Calc]),0,[txt42Calc]))+
(Iif (IsNull([txt45Calc]),0,[txt45Calc]))+
(Iif (IsNull([txt48Calc]),0,[txt48Calc]))+
(Iif (IsNull([txt51Calc]),0,[txt51Calc]))+
(Iif (IsNull([txt54Calc]),0,[txt54Calc]))+
(Iif (IsNull([txt57Calc]),0,[txt57Calc]))+
(Iif (IsNull([txt60Calc]),0,[txt60Calc]))
All the [txt..Calc] are calcutated text boxes themselves. I guess I am just wondering if there is a simple way to ditch the 'IIf IsNull' segments.
Any help appreciated!
Thanks.