z.B.

SELECT *
FROM [Tabelle]
WHERE (((Datum_Feld)>#11/30/2006# And (Datum_Feld)<#1/1/2007#));