Modifying a sort

[Hank.School]

Hello,

I know how to sort the results of a query alphabetically but I was wondering if there is an easy way to have one specific value out of order.

I have a list of about 30 options with one of them being 'N/A'. Is there a way to have the options sorted alphabetically but then move N/A to the top of the list?

Thanks
Hank

 

[Uncle Gizmo]

The usual way of doing this would be to precede N/A with a space a star "*" or possibly an underscore..

 

[jdraw]

You could use " N\A" -- I think it will collate before "A".
Perhaps you could show us some sample data.

 

[Hank.School]

Well, the data is a list of subway lines in NYC. The users will be entering locations and will have the option to select one of the lines from a dropdown or N/A if the location is not generally walkable from the subway. The trick of preceding it with a space should work nicely, thanks a lot guys!