between dates

[tuzojazz]

Hi:I have a table named "Calls"Calls----------------------------Id Date----------------------------2 04/04/2006 11:33:073 04/04/2006 11:35:27-----------------------------Both records have the same date but different timeWhen I make this query I don't get records-------------------------------------------------SELECT Id, Date FROM CallsWHERE Date BETWEEN #4/4/2006# AND #4/4/2006#-------------------------------------------------Why I don't get records If all records in table "Calls" have 04/04/2006 on column "Date"?Thanks!

[pulpfiction]

write the query like this, then it will retrieve all the records of the date 4/4/2006SELECT Id, Date FROM CallsWHERE Date BETWEEN #4/4/2006# AND #4/5/2006#