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
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top