hal9000 Posted January 12, 2011 Share Posted January 12, 2011 I have a number field with values ranging from 1-50. When I sort on this field, it sorts like text, like this: 1 11 12 13 14 15 16 17 18 19 2 20 There must be a way to sort like a number, no? Thanks! Link to comment Share on other sites More sharing options...
comment Posted January 13, 2011 Share Posted January 13, 2011 Are you SURE it's a number field? 1 Link to comment Share on other sites More sharing options...
hal9000 Posted January 13, 2011 Author Share Posted January 13, 2011 I guess it wasn't, because when I created a calculated field based on the number field and used the getasnumber function, it sorted properly. I guess I thought the act of importing numbers into a number field would make them numbers, but I guess that's now how it works. Link to comment Share on other sites More sharing options...
Lee Smith Posted January 13, 2011 Share Posted January 13, 2011 Are you SURE it's a number field? It will if the field in FileMaker is a number.. To Check that the field type is a Number, File > Manage > Database Lee Link to comment Share on other sites More sharing options...
bruceR Posted January 13, 2011 Share Posted January 13, 2011 I guess it wasn't, because when I created a calculated field based on the number field and used the getasnumber function, it sorted properly. I guess I thought the act of importing numbers into a number field would make them numbers, but I guess that's now how it works. No, importing numbers into a text field does not change the field type. You must DEFINE the field type as number. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4845 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now