ISlp59lp Posted August 26, 2013 Report Share Posted August 26, 2013 I have a database of a football roster. The player numbers are like: 1, 2, 3, 10, 11, 20, 30,... Yet, when I sort them in the datapage, the results are: 1, 10, 11, 2, 20, 3, 30, ... How can I get the desired results of: 1, 2, 3, 10, 11, 20, 30, ... Note: football numbers are 1, 2, 3 -- not 01, 02, 03 Quote Link to comment Share on other sites More sharing options...
0 HongTaiLang Posted August 27, 2013 Report Share Posted August 27, 2013 If the data type is Text255 in the table, the sort will be 1, 10, 11, 2, 20, 3, 30... Because it sorts text alphabetically, and 1 is before 2. If the data type is Number in the table, the sort will be 1, 2, 3, 10, 11, 20, 30,... Quote Link to comment Share on other sites More sharing options...
Question
ISlp59lp
I have a database of a football roster.
The player numbers are like: 1, 2, 3, 10, 11, 20, 30,...
Yet, when I sort them in the datapage, the results are: 1, 10, 11, 2, 20, 3, 30, ...
How can I get the desired results of: 1, 2, 3, 10, 11, 20, 30, ...
Note: football numbers are 1, 2, 3 -- not 01, 02, 03
Link to comment
Share on other sites
1 answer to this question
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.