You mentioned earlier about "sorting" but not alphabetically -- Book, Translation, Article. There's only one way I can think of to do this -- well, actually two ways. The first way would be to have another field with the sort order. Book would have a "1" in the field, Translation would have a "2" and Article would have a "3." It could pretty easily be done without your having to manually enter the values. The other way would be to stick the numbers at the beginning of the categories -- 1Book, 2Translation, 3Article. Then it would sort the way you want. You could chop off the first character when you print it out so the numbers wouldn't be seen. You could even have the stick the numbers in so you wouldn't have to do it.

---

I found this thread and this is what I am trying to do on my database (for a list of ranks). I understand the first part adding the number in front. But, the last part..."chopping off the first character when you print it out"...where and how do you do that?

Thanks.