Sort by a value

[AndyShuter]

I was just wondering if it was possible to run a query by a specific value first, then the remainder of the following values in ascending order.

For example, the data would appear in the table as

Smith
Bloggs
Jones
Taylor

What I would like to do is have all the Taylors at the top, followed by Bloggs,Jones then Taylor

I have looked at the OrderBy function, but believe that you can only sort Ascending and Descending

Checked search, cant find anything

Many Thanks

Andy

 

[ScottGem]

The only way to do this is by adding an order field that contains a numerical sort value. Then sorting on that field.

 

[QTNM]

Not sure I understand ..... you want the Taylors at the top and then show also in the alpha listing at the bottom again ( in this case cuz it's the last in alpha order ).

QT

 

[AndyShuter]

Thanks

Thanks scott, that worked fine

Andy