strSql = "Select Newsid, Heading, Preamble, Paragraph, Filename, Regdate " & _
"From News order by iif( Newsid = " & Newsid & " 0,1) , Regdate Desc "
Frågan#1
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?
