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
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?
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
like to total. I used the expression builder to create-----Original Message-----
We've created a form that includes values that we would
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?