Ordering numbers as text

[TSGB]

Hi I have a problem if one of my fields I chamge it to a text field.( I need to add some text on it) on an ascending ordered report it orders 10 then 100 then 5. How can I order properly my field not as a number but as a text field

regards,

[Nathan H]

Hi I have a problem if one of my fields I chamge it to a text field.( I need to add some text on it) on an ascending ordered report it orders 10 then 100 then 5. How can I order properly my field not as a number but as a text field

regards,

My understanding is that is how it will order it in a text field. Reading left to right, 1 comes before 5. Suggest adding your text in a different field.

[TSGB]

HI Yes but 10 comes before 5 in this case

Thanks,

[Nathan H]

HI Yes but 10 comes before 5 in this case

Thanks,

Yes, but it is no longer 10, you converted it to text and so it is now 1 and a zero. Reading left to right, 1 comes before 5, so that is why you are seeing the sort order as 1,10,100,2,20,200, etc...

In a query, use this Val([field1]) which will return the number value and give you the sort you are looking for.

[missinglinq]

You say you need to "add some text to it." Is this text the same each time, or is it always the same number of characters? Tell us a little about this.

The standard way to make digits entered as text order as you want is to add leading zeros thru formatting, but in a mixed alpha-numeric text field, you'd have to separate the alpha from the numeric component.

Welcome toTheScripts!

Linq ;0)>