Advanced Sort - Not Alphabetical

[eques4]

Hi All

I want to sort my records in my datasheet by more than one field but I want one category in one of the fields to be placed first.

The name of this category is "L" but there are other categories that come first in the alphabet (eg "P" and "V")

Is there a way I can make it sort in an order I specify?

Many thanks

Harry

 

[mndrlion]

You will need to create a separate sorter field. If your categories are already in a separate category table, you can add a sorter field there. The category that you want to be first would have a sorter = 1, etc.