I feel like I've asked this before. How do I make a field based on another
field in the same query?
exp1=a+b
exp2=val(expr1)
How do I write expr2?
Kou
Your above question can have more than one result depending upon field
datatype and what you mean by using the "+".
Did you want to concatenate or add?
Since your Exp2 refers to Val() I would have to assume that a and b
are text datatypes.
Let's assume a = 3 and b = 5
If a and b are Text datatypes
Exp1:"3" + "5"
the result is text "35"
Exp2:Val("3" + "5")
the result is the number 35
However, if a and b are Number datatypes
Exp1:3 + 5
the result is 8
Exp2 is not needed.
Best I can do for you with the information you have given.