selecting records between dates

[schumi52]

Hello,

i'm trying to select records between two dates...but can't get it to work. I've already searched for a lot of ways to do it, but can't get any of them to work...please help, i'm using vb2008 and access...below mij code...

            da = New OleDb.OleDbDataAdapter("SELECT factuurnr, debiteurnr, factuurtype, factuurdatum, betaald, medewerker, factuurverstuurd, referentie FROM tblFacturen WHERE factuurdatum BETWEEN " & van.Value & " AND " & tot.Value & ";", verbinding)
            da.Fill(ds)

[jmcilhinney]

Don't use string concatenation to insert values into SQL statements. Use parameters EVERY time. Follow the Data Access link in my signature for some examples.