1 Reply Latest reply: Mar 16, 2018 3:16 AM by Steve Caiels RSS

    concatenate function does not work with a % field

    vanessalowther _

      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?

        • Re: concatenate function does not work with a % field
          Steve Caiels

          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.