มือใหม่ Windows Form ขอความช่วยเหลือเกี่ยวกับการเลือกช่วงเวลาข้อมูลใน MS Access ครับ

 date1 = dateTimePicker1.Value.Day;
     month1 = dateTimePicker1.Value.Month;
            year1 = dateTimePicker1.Value.Year;
            date2 = dateTimePicker2.Value.Day;
            month2 = dateTimePicker2.Value.Month;
            year2 = dateTimePicker2.Value.Year;
            datetime1 = date1.ToString() + "/" + month1.ToString() + "/" + year1.ToString();
            datetime2 = date2.ToString() + "/" + month2.ToString() + "/" + year2.ToString();
string q = "Select * from WeightData WHERE W1Date >#" + datetime1 + "# and W1Date<=#" + datetime2 + "# ORDER BY W1Date";
            cmd.CommandText = q;
            cn.Open();
            dr = cmd.ExecuteReader();