Display Record between two dates

[gibra]

You can use WHERE ... BETWEEN, like this:

    Dim sql As String
    sql = "SELECT fields_list "
    sql = sql & " FROM table 
    sql = sql & " WHERE field_date BETWEEN #" & DatePicker1.Date & "# AND #" & DatePicker2.Date & "#"