Scusate come si applica la cluasola order by data in una query di questo tipo:?
codice:
SQLDown = "select * From ListFiles WHERE 1=1"
If CAT <> 0 then
   SQLDown = SQLDown & " AND ID_CAT = "& CAT &" "
End if
If UOAT <> 0 then
  SQLDown = SQLDown & " AND ID_UOAT = "& UOAT &" "
End If
If ucase(trim(cp)) <> "TUTTI" then
  SQLDown = SQLDown & " AND CAB = '"& CAB &"' "
End If
If DATA <> "TUTTE" then
 SQLDown = SQLDown & " AND DATA = #"& DATA &"# "
End If
Set RECDown = ConnDown.Execute(SQLDown)