here's my code:

Set rs1 = adconn.Execute("SELECT * from ApplDetail where appr = true and level1 = false and apprdate >= " & DTPicker1.Value)

apprdate is a date type data, in Access.
however, i failed to compare it with my DateTimePicker's value... it doesn't return the expected result.
the rs1 recordset is to be retrieved by a DataReport, so only SQL statements can be used...
can you help me this time?
thanks.
Yih