Listing Data between two Dates

[Andy1723]

Some thing like this

"Select fieldname,fieldname from tablename where fieldname Between #" & datepicker start date & "# And #" & datepicker end date & "#"

I did assume you are using Access as a backend that is why the date values are inside pound signs

Access is not doing any of the work, just retrieving data from my visual basic programming. When I try using that I get an error saying "Expected Case".

[Andy1723]

startDate = DatePart("d", dtpStartDate)
endDate = DatePart("d", dtpEndDate)
 
    Do Until startDate = endDate
        While Not found And Not tblBooking.EOF
            If tblBooking!Date = dtpStartDate Then
                found = True
            Else
                tblBooking.MoveNext
            End If
        Wend
    Loop

I got this so far, but my program keeps crashing, any ideas why??

Thanks you for everyone who's helping, i'm really stuck