I have a db that keeps track of my vacuum tube inventory. When I sort by tube number, the order is not really by tube number.
1V2 should be just below the 0Z4, and the 3AL5 would be next. The 6146 should be next to last.
Tube numbers will start with 1 or 2 digits, followed by letters, or be 4 digits. I tried unicode sorting but no effect.
1 record for each tube, 1 field containing the tube number. Other fields in the record are for location, condition, cost, etc.
Finding records by tube number is of course easy, but printed out lists are not correct.
I could use a script but not sure where to start. There are about 300 different numbers in this database.
Any help appreciated.