G'day All,
I have a database which is used to store vehicle fleet information.
Within the database I need to sort a field "Body #". This field is formated as text as there are body numbers which start with letters. I have a query which sorts out a particular body builder and the body numbers which are returned are two numbers, separated by a "-" followed by three more numbers (ie 87-145). When I do a ascending sort, I get results 00-123, 01-123, 02,-123, 88-123, 89-123, 99-123 etc. What I need to do is change the order so first body number would be 88-123, 89-123 and when it gets to 00-123, put that after 99-123. The first to digits are the last two digits of build year. 1988 = 88-123, 2000 = 00-123 etc. The final three are the build number within the build year.
A long winded description I know lol Sorry for that. Can anyone help please?? I'm at a bit of a loss with this one.
Thank You in Advance
Anthony
I have a database which is used to store vehicle fleet information.
Within the database I need to sort a field "Body #". This field is formated as text as there are body numbers which start with letters. I have a query which sorts out a particular body builder and the body numbers which are returned are two numbers, separated by a "-" followed by three more numbers (ie 87-145). When I do a ascending sort, I get results 00-123, 01-123, 02,-123, 88-123, 89-123, 99-123 etc. What I need to do is change the order so first body number would be 88-123, 89-123 and when it gets to 00-123, put that after 99-123. The first to digits are the last two digits of build year. 1988 = 88-123, 2000 = 00-123 etc. The final three are the build number within the build year.
A long winded description I know lol Sorry for that. Can anyone help please?? I'm at a bit of a loss with this one.
Thank You in Advance
Anthony