SELECT Appoiments.Startdate, Appoiments.Enddate
FROM Appoiments
WHERE (((CDate("1.10.2005"))<=(CDate([Appoiments]![Enddate]))) AND ((CDate( _
  "10.10.2005"))>=(CDate([Appoiments]![Startdate]))))
ORDER BY Appoiments.Startdate;