Concatenation

[Zinger]

Is there any way in MS ACCESS to join string & integer in field which has data type: number? And later on to use those numbers for calculation.

I want to store in field something like this:

5,6 - 9

in excel i should do this =12 &" - "&11



Thanks in advance

[June7]

Eval() function can take a string that is a math expression and evaluate it. So:

Eval("1" & "+" & 4) = 5

The , is decimal? So yes, if "5,6 - 9" is stored in field:

Eval([fieldname]) = -3.4

[Zinger]

Hi June7! First of all i want to thank for your suggest... But what i really want to write there, it is "5,6 to 9", where " to " or " - " has string. And get those number and place to another field through some statements.

Thanks