Hello everyone...I am new to this forum. I have an Access 2000 question that seems to be stumping even our helpdesk here. Here is what I am trying to accomplish, I receive a report in Excel with the following two fields "Start Date" i.e. 7/1/2007 to an "End Date" 02/28/2011. I can import this table into Access then what I would like Access to do is to look at the dates and to go (using the example) from the start date (7/1/2007) to the end of the year (12/31/2007) then create a new line and start with the next year (01/01/2008) in the start field and end with (12/31/2008) and so on until it reaches EOD. I would really appreciate any help...not sure if this can actually be done...thanks for the help.

Can't help you with access but if you want to do it in SQL use a while statement to loop, adding a single row of data, then use a dateadd function to add a date, and loop until the date your working on is hit (12/31/2008.

Thanks...I will give that a try and see how I make out.