Sorting in numerical order

[hal9000]

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!

[comment]

Are you SURE it's a number field?

[hal9000]

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.

[Lee Smith]

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

[bruceR]

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.