WilliamWIT Posted July 28, 2005 Share Posted July 28, 2005 I've created a Door Schedule with about 25 seperate doors. Each door has an ID number, from 1-25. My problem is that when the Schedule is created, the database is arranged by numbers that start with 1 (1, 11,12,13 etc.) and then 2 (2,22,23). I have not been able to change the arrangement to 1-10-10-20 and so forth.. any suggestions? Quote Link to comment
ron Posted July 29, 2005 Share Posted July 29, 2005 Put a 0 in front of single digit numbers. Quote Link to comment
WilliamWIT Posted July 29, 2005 Author Share Posted July 29, 2005 Yes, thats what I thought of doing, but I wonder if its possible to order them 1-25 without putting a 0 in front of them Quote Link to comment
J. Johnson Posted July 29, 2005 Share Posted July 29, 2005 Instead of using a 0, use a space. That works for me. Good luck. Quote Link to comment
WilliamWIT Posted August 1, 2005 Author Share Posted August 1, 2005 Ok that worked great. Putting a space before each single digit entry results in a list that goes 1-25 properly. Thanks for the help Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.