range to records

[hello]

Hi.
I have a table with names. Start date. End date.
For example : sarah 2007-03-04 2011-03-02

I want a query with a record (row) for each year.
Thanks

 

[hello]

Or a form there you type in a date range which ends up with all the dates between in a table

 

[Cerial]

I think this is what you want:

SELECT table1.names, table1.[Start date], table1.[End date] FROM table1 WHERE [Specify Year] BETWEEN Year(table1.[Start date]) AND Year(table1.[End date])