using Switch function and order by

[shank]

I'm trying to use the switch function in an order by clause. It works except for descending attribute.

Example: COL="title_desc", GenKTitles.Title & " DESC" <-- this does not cause an error, but does not work either.

Example: COL="title_desc", GenKTitles.Title DESC <-- this causes a missing operator error

None of the DESC attributes work below. What is the proper syntax for getting DESC into this statement?
thanks!
==============
ORDER BY Switch(COL="orderno_asc", GenKStock.OrderNo, COL="title_asc",
GenKTitles.Title, COL="artist_asc", GenKTitles.Artist,
COL="description_asc", GenKStock.Description, COL="orderno_desc",
GenKStock.OrderNo & " DESC", COL="title_desc", GenKTitles.Title & " DESC",
COL="artist_desc", GenKTitles.Artist & " DESC", COL="description_desc",
GenKStock.Description & " DESC");
================

 

[shank]

switch

try this...

ORDER BY Switch(COL="orderno_asc",GenKStock.OrderNo,COL="title_asc",GenKTitles.Title,COL="artist_asc",GenKTitles.Artist,COL="description_asc",GenKStock.Description,True,1), Switch(COL="orderno_desc",GenKStock.OrderNo,COL="title_desc",GenKTitles.Title,COL="artist_desc",GenKTitles.Artist,COL="description_desc",GenKStock.Description,True,1) DESC;