Sorting by serial #

[puterco]

Filemaker sorts numbers so that 10 comes before 9 etc:

ID: Record:

10 Record C

8 Record A

9 Record B

I quess this isn't a big problem but if I only have <20 records it bothers me in list view those rare times when I sort something by their IDs. Is there a way to easily make FM sort numbers properly? I know that I could manually add a zero before the nine, but I would rather hear a different tip.

[JerrySalem]

Make sure the type of field for your serial number is actually a Number.

this might make the sort work.

Jerry

[Kurt Knippel]

quote:

---

Originally posted by puterco:

Filemaker sorts numbers so that 10 comes before 9 etc:

ID: Record:

10 Record C

8 Record A

9 Record B

---

If formatted as Text this is the correct sort order, but if the ID is formatted as a number then it will sort in the expected order. You can also pad the numbers with leading zeros if you want to keep them as text.

For example:

ID: Record:

0008 Record A

0009 Record B

0010 Record C