Please point me in the right direction .
i have the results of four separate list boxes in four separate text boxes, No problem. I Now wish to add or sum of the four totals into one text box .
i have tried the following in the control source of the text box :
# =Nz([List341].Column(0))+Nz([List346].Column(0))+Nz([List929].Column(0))+Nz([List931].Column(0))#
and receive and invalid syntax error
Am i going about this the wrong way ?
Regards Ypma
i have the results of four separate list boxes in four separate text boxes, No problem. I Now wish to add or sum of the four totals into one text box .
i have tried the following in the control source of the text box :
# =Nz([List341].Column(0))+Nz([List346].Column(0))+Nz([List929].Column(0))+Nz([List931].Column(0))#
and receive and invalid syntax error
Am i going about this the wrong way ?
Regards Ypma