rs.Open "SELECT * FROM [transaction] WHERE t_date=" & Date, db, adOpenStatic, adLockOptimistic


hi...
this sql query didn't work?????

t_date is a date/time (data type) field in access database...

i can't compare it with the current date.....so that all those records with the current date can display in a listview control...

in the database there is a few records which its t_date field is current date....but when i compare it with the sql query above...it didn't match and didn't display in the listview control..

how to compare it??
what is the problem??