I have a date/time field in my access database (ie stored like 06/07/00 12:00:00) and I wish to do an SQL to find certain dates (ie. ignoring the time part of the data) I'm doing this:

sSqlTxt="SELECT * FROM Letters WHERE DateSent = #" & Format(dtFrom.Value, "DD-MMM-YYYY") & "#"

There are many records that match this, but this sql is not picking up anything. I think is something to do with the fact that it is comparing a Date/Time with just a date.
I need the data in the database to contain the time with the date, but as far as this particular SQL goes, I just want to compare dates.

Anyone know where am I going wrong ?
Why is date handling within databases SO FIDDLY ?????