🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

concatenate function does not work with a % field

User: "Altair Forum User"
Altair Forum User
Altair Employee
Updated by 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?

Find more posts tagged with

English
Monarch
Sort by:
1 - 1 of 11
    User: "Altair Forum User"
    Altair Forum User
    Altair Employee
    OP
    Updated by 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.

Quick Links