hello,

i need to select records between 2 dates from a table called tblVaccinatie with columns :
- VaccinatieId
- VacDatum
- VacProdukt
- PatId

i am using this code now, but it isn't working

strVaccinatie = "Select * from tblVaccinatie where VacDatum between #" & _
dteVan & "#" & " and " & "#" & dteTot & "#"

dteVan and dteTot are the values of two datepicker controls

if u need more info to solve my problem, please tell me what is lacking

thnx, Koen