Need to add a Numeric to strings

[Newbie69]

I need to add a numeric to a bunch of strings

example
{Query.Number}+"-"+{Query.User_FName}+" "+{Query.User_LName}

where Query.Number is a Numeric

It says it is looking for a number after the first addition.

Can anyone help

 

[dgillz]

Try-
totext({Query.Number})+"-"+{Query.User_FName}+" "+{Query.User_LName}

Check out the help files for totext. It has several arguments to control # of decimals, thousands separators, decimal separators, etc. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[mbarron]

Instead of using +'s use &'s (ampersands). Mike