DAte runnning down a column as an SQL statement plz

[Guest_imported]

my need is not that complicated I think! I just want the date from 1.1 of the year I select, until 31.12....so I should have 365 rows when I select a year,sya,2001 with, say, a combo box full of years!!
How do I do this please?
Kingz

 

[Cagliostro]

Try following
select * from xxx where yourdate between '01/01/2001' and '31.12.2001' John Fill