Whats wrong with this SQL query?

[uven80]

Im trying to search a MS Access database for a specific date. Im getting a an error message, translated to english its something like: "typeerror in query". The column's type is a Date/Time with the format short date.

the query is as follows:
SELECT Personel.Sign, Personel.Firstname, Personel.Lastname, Absent.Date
FROM Personel, Absent
WHERE Absent.Date = '" & datetimepicker.Value.Date & "' AND Personel.Sign = Absent.Teacher_Sign

Would really appreciate help

[RichardAtherton]

#" & Format(DateTimePicker1.Value, "MM/dd/yyyy") & "# is how date comparisons should be made

i.e the date enclosed in # and in the fomrat of MM/dd/yyyy

[uven80]

Sweet, was the ' instead of the # surrounding the phrase that messed it up. Thanks a bunch!