addition operator doesn't work in expression buidler

P

Pete Sheridan

Hello Mechelle,
From what you put into your request, it appears that the
two fields are 'string' type data (text). If that is so,
use the '&' operator to concantenate the two fields;
ie. =[Eligibility]&[Citizenship].
If you want a space between the fields do the following,
=[Eligibility]& " " &[Citizenship].
If you want a comma between the fields do the following,
=[Eligibility]& "," &[Citizenship].

Hope this helps, Pete
-----Original Message-----
We've created a form that includes values that we would
Click to expand...
like to total. I used the expression builder to create
the following formula: =[Eligibility]+[Citizenship].
However, the arithmetic operator (+) isn't totaling the
values. I've tried the other operators (*,-,or /) in the
formula to see if they work. Each of these other
operators perfom the mathematical operation (multiply,
subtract or divide) they are supposed to do. The addition
sign just won't add! What is the fix for this problem?
 
Top