Custom sort order

[Billy Rogers]

I have a query that returns rows like this

F
K
S
T

Is there a way to sort the rows to look like this?
F
S
K
T


--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/

 

[Klatuu]

FSKT

You could create a calculated field in your query than translates the field
into a ranking number and sort on that:

SortBy: =Switch([Fld] = "F", 1, [Fld] = "S", 2, [Fld] = "K", 3, [Fld] = "T",
4)

 

[Billy Rogers]

Fantastic!

Thanks a million.
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/

FSKT

You could create a calculated field in your query than translates the field
into a ranking number and sort on that:

SortBy: =Switch([Fld] = "F", 1, [Fld] = "S", 2, [Fld] = "K", 3, [Fld] = "T",
4)
--
Dave Hargis, Microsoft Access MVP

I have a query that returns rows like this

F
K
S
T

Is there a way to sort the rows to look like this?
F
S
K
T


--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

http://thedataguru.blogspot.com/