Ordinare dati di una query where 1=1

[fraude]

Scusate come si applica la cluasola order by data in una query di questo tipo:?

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)

[Roby_72]

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
SQLDown = SQLDown & " ORDER BY DATA" Set RECDown = ConnDown.Execute(SQLDown)

rOBY

[fraude]

Thanks!