select vald post sen övriga

Halåjs!
Har denna kod

strSql = "Select Newsid, Heading, Preamble, Paragraph, Filename, Regdate " & _
"From News order by case Newsid when " & Newsid & " then 0 else 1 end , Regdate Desc ;"

funkar med sql-server men inte access, går den att bygga om så den funkar till access?

strSql = "Select Newsid, Heading, Preamble, Paragraph, Filename, Regdate " & _
"From News order by iif( Newsid = " & Newsid & " 0,1) , Regdate Desc "

Tack & bock! :bire