hi,

i have a table with one field(edate) is date(format -short date)type in access 2003 database- VB 6.0. i want to search in the table and display the records in between two dates. those dates are picked up from the DTPicker1 and DTPicker2 control. My sql stt., is

strsql="select * from mytable where edate between #" & DTPicker1.value & "# and #" & DTPicker2.value & "# ".

am not getting the exact records as i expecting. is anything wrong in this query. and even i tried >=dtpicker1.value and <=dtpicker2.value. This too not working

saj