Thanks, worked very well

had a little trouble with the syntax

the correct syntax is

SELECT * FROM TableName WHERE datecolumn BETWEEN #15/04/2009# AND #22/04/2009# AND datepart('h',datecolumn )>=9 AND datepart('h',datecolumn )<=13