Is this possible? MS Access query selecting a field to be on top and others will be in alpha order

Question

Example i have a table:

----------------------
 ID. | Color
----------------------
 A1.  | Red
 A2.  | Yellow
 A3.  | Blue
 A4.  | Black
-----------------------

Is this possible to sort a table like this? specify a field to be on top (example: Yellow) then the other records will be in alphabetical order. the Color field can only be sorted.

----------------------
 ID. | Color
----------------------
 A2.  | Yellow
 A4.  | Black
 A3.  | Blue
 A1.  | Red
-----------------------

Is there a query related to this? Thanks.

score 1 · Answer 1 · answered Jul 26 '18 at 10:28

1

You can use:

Select
    ID,
    Color
From
    YourTable
Order By
    Abs([Color] = "Yellow") Desc,
    Color Asc

answered Jul 26 '18 at 10:28

Gustav

53,498
7
29
55

score -1 · Answer 2 · answered Jul 26 '18 at 08:45

-1

select *
from something
order by
 case when Color = "Yellow"  then "1"
 else Color 
end

answered Jul 26 '18 at 08:45

M.Ali

67,945
13
101
127

Sorry. can you do that in MS Access sql? – Melz Jul 26 '18 at 08:53
3

`CASE WHEN` is T-Sql, not Access Sql. – Andre Jul 26 '18 at 10:30

Is this possible? MS Access query selecting a field to be on top and others will be in alpha order

2 Answers2