I have a table with curdt field with datatype datetime in ms-access. the entries in curdt as follows:1/28/2011, 2/9/2011 etc.
I have a form with two datepickers with custom format of dd/mm/yyyy.
my query is like
select * from table where curdt between #dtfr# and #dtto#
where dtfr= datepicker1.text and dtto= datepicker2.text
I have a problem that when i select records from table only records that have entries are displayed. e.g
I have entries for 14 jan 2011 and 15 jan 2011
when i select 8 jan 2011 in from dtpicker and 15 feb 2011 in to dt picker i did not get result. even i have records in between that time period.
I hope i put my issue clear.