Sorting a recordset

**SortedSites** · Sep 3, 2012 06:14

Hi

I have the following query

Code:

SELECT [eventid], [name],[date] FROM events WHERE eventid IN(22,13,18)

**r937** · Sep 3, 2012 06:37

very possible

Code:

ORDER
    BY CASE WHEN eventid = 22 THEN 'curly
            WHEN eventid = 13 THEN 'larry'
                              ELSE 'moe' 
        END

**SortedSites** · Sep 3, 2012 06:44

Originally Posted by r937

very possible

Code:

ORDER
    BY CASE WHEN eventid = 22 THEN 'curly
            WHEN eventid = 13 THEN 'larry'
                              ELSE 'moe' 
        END

Thanks Rudy, and I should have probably made this clear in my original post, is that valid for Access SQL or is some bizarre syntax required?

**SortedSites** · Sep 3, 2012 06:49

Scratch that I think I have it!

Code:

SELECT eventid,[name],[date] FROM events WHERE eventid IN(22,18,13) ORDER BY IIF(eventid = 22,'curly',IIF(eventid = 13, 'larry','moe'))

**r937** · Sep 3, 2012 07:18

ace! (you got it in one)

p.s. if you add a 4th event id, you can use 'shemp' -- but after that, curly joe and joe would be out of sequence

**SortedSites** · Sep 3, 2012 07:45

Originally Posted by r937

ace! (you got it in one)

p.s. if you add a 4th event id, you can use 'shemp' -- but after that, curly joe and joe would be out of sequence

Thanks, fortunately I only need to go to 3.

User Tag List