concatenate function does not work with a % field

Altair Forum User

Have tried to create a text field that is formed of both fields and added text. One of the fields I need to include is a % number field. Which does not work as it is wrong field format

 

Have tried to convert this field to a text field using Chr() funtion, but the result is a blank field.

 

How do I convert a % number to text so that it can be included in a concatenate function?

Altair Forum User

Hi Vanessa,

 

The STR() function will convert a numeric field to character.  By default, I believe it creates a 10 character long, right justified field.  There are a few options such as length, decimals and padding character to override these, but the easiest option is usually :

 

Trim(Str([YourField]))

 

Depending on how your decimal is formatted, you might need to multiply by 100 and use the optional characters and use something like :

 

Trim(Str([YourField]*100,5,2,""))

 

CHR returns the ASCII character for a given number.  CHR(65), for example, returns the character 'A'.

 

Regards,

Steve.