Field A = "101" and Field B="5" and i am trying to return a numeric field showing"1015"
i am using V8 if that makes any difference.
Thanks in advance[/quote]
You can only concatenate character fields so your formula needs to convert each field to Character, then concatenate, then (maybe?), convert back to numeric. You need the STR() function.
However from what you are doing it sounds like the values could, maybe should probably be left as character fields.