trying sum of 3 fields , enter in fourth text box on same report. particular report,
empnose =78 empright=555 empleft= 565 the total text box should 1198
using expression
=sum([empnose] , [empright] , [empleft]) the result -4
using expression
=sum([empnose]+[empleft]+[empright]) the result 226514940
using expression
=([empnose]+[empleft]+[empright]) the result 78555565 (the 3 values concatenated)
what correct syntax?
if want add values of current record only, sum() wrong, because sums on records.
=([empnose]+[empleft]+[empright]) should correct. if concatenates values seems fields text fields instead of numbers?
if can't change datatypes numbers, can try
=(val([empnose]) + val([empleft]) + val([empright])) the val() function tries convert string number.
Comments
Post a Comment