Hi everyone, would anyone be able to help me out?
I would like to ask what would be the best/easiest way to be able to sort a text field as numeric? I have a customer database, and the 'House/Flat Number' field is a text field as it has to contain letters aswell, i.e. 41b, etc, and in a very small amount of cases the customer has a house name instead of a number. The problem is that now i'm starting to build reports, output the data, bla bla and i'm obviously having the sort order come as 1,111,21,210,34,4,5,56, etc.
So i just wanted to ask for some help with this. I'm still learning at the moment so please try not to be too technical with me
Is there a way of just having leading zero's? I would not need more than 3 so that would be acceptable, but i guess there's no way of hiding them?
What other ways are there of doing it? Thanks for any help any one can give, it is much appreciated.
I would like to ask what would be the best/easiest way to be able to sort a text field as numeric? I have a customer database, and the 'House/Flat Number' field is a text field as it has to contain letters aswell, i.e. 41b, etc, and in a very small amount of cases the customer has a house name instead of a number. The problem is that now i'm starting to build reports, output the data, bla bla and i'm obviously having the sort order come as 1,111,21,210,34,4,5,56, etc.
So i just wanted to ask for some help with this. I'm still learning at the moment so please try not to be too technical with me
Is there a way of just having leading zero's? I would not need more than 3 so that would be acceptable, but i guess there's no way of hiding them?
What other ways are there of doing it? Thanks for any help any one can give, it is much appreciated.