Sortere i Access-db ud fra dato via Sql

DIM sSQL as STRING

sSQL = "SELECT * FROM YourTable WHERE Dato BETWEEN #" & Format(DateFrom, "yyyy-mm-dd)
sSQL = sSQL & "# AND #" & Format(DateTo, "yyyy-mm-dd) & "#"

Cant be far out!

>> terry
Tak for svaret, men der er noget galt.
Hele syntaksen bliver rød.

Er der noget med, at i et datofelt i Access ligger der et skjult klokkeslæt?
/Søren

If you dont use the time then this should still work!

If the syntax in VB becomes red then its because I forget a " sorry :o)

sSQL = "SELECT * FROM YourTable WHERE Dato BETWEEN #" & Format(DateFrom, "yyyy-mm-dd")
sSQL = sSQL & "# AND #" & Format(DateTo, "yyyy-mm-dd") & "#"

Det var bedre. Tak for det

UPS. Prøver igen :-)

selv tak