Concatenating a Text Field and a Number Field 
Author Message
 Concatenating a Text Field and a Number Field

Thank you, guys...


Quote:
> {monthname}+' '+totext({year},0)

> the ,0 means 0 decimal positions



Sun, 01 May 2005 23:22:18 GMT  
 Concatenating a Text Field and a Number Field

Hello!
I'm trying to use a formula field to Concatenate a text field named 'MonthName" and a number field named "Year"  The problem is that it looks like this:  
"SEPTEMBER 2,002.00".
My intention is to make it look like a normal year: "SEPTEMBER 2002" How can this be done?

Thankx in advance...



Sun, 01 May 2005 22:00:04 GMT  
 Concatenating a Text Field and a Number Field
{monthname}+' '+totext({year},0)

the ,0 means 0 decimal positions



Sun, 01 May 2005 23:11:14 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Convert number field to text field.

2. Having trouble accessing single field key with two concatenated fields

3. Reading a field and using that field to place a number in another field

4. Bolding text in concatenated fields

5. Concatenating data fields with text

6. When you create a field each field has a id number (field number) (how can you edit this number)

7. Breaking up a phone number field into seperate fields

8. Filter A Report From a Pop-Up Box for Text, Numbers, and Yes/No Field Types

9. Sorting Numbers in Text Field

10. Sorting Numbers in Text Field

11. Associating Number/Text Fields

12. Extracting a number from within a text field

 

 
Powered by phpBB® Forum Software