A special Format for number needed

[wjoc1]

I have a sinking feeling this is not possible but I'm going to throw it out there anyway.

I have a field in my database and it stores Pole numbers. Generally these are 1,2,3,4,5,6, etc. etc. etc. Lovely and no problems there.

However my end-user has a special numbering system for certain types of poles. For example, they may need to record a Pole number as 2A or 23S.Thats fine too, so I just changed the format of the field to text.

Now however I cannot order the numbers in Ascending or Descending order as the case may be, because they are not ordered numerically but alphabetically ( because it is now "technically" a text field).

So while before I had the following: (with general number format)

1,2,3,10,16,21,23,35,

I now have: ( with text format)

1,10,16,2,21,23,3,35

I need some kind of "numeric"-"text" format.
Is there anyhting that I can do besides having a breakdown ?

Thanks,
Liam

 

[wjoc1]

Thanks Pat, that solved it perfectly!

Liam