Sunday, February 16, 2003 03:43 PM
First of all, you should consider using a prepared statement so you don't have to worry about getting the date syntax right.
Access is trying to find matches for 1/30/03 at exactly midnight. As it is unlikely that your transactions occurred at this exact time, the query doesn't work. You need to use:
send_date > '01/29/2003' and send_data < '01/31/2003'
The Calendar class is good for adding/subtracting one day from your original date.