Splitting Date Range Records in Access

[dfritt]

I have a table with records that I want to split up based on a start and end date. I am new MS Access and VB and would appreciate an example of some code that could be used to do this ?, even through Excel would be fine

Example :

Leave Record Table

Employee Start_Date End_Date Units Taken
001 2007/10/01 2007/10/03 3
002 2007/10/02 2007/10/04 2

Split into a New Table

Employee Date
001 2007/10/01
001 2007/10/02
001 2007/10/03
002 2007/10/02
002 2007/10/03
002 2007/10/04

[Rabbit]

Why do you need the data represented this way?

[dfritt]

The reason for splitting the records.

I want to match off information obtained from a access control system.

The access control system data

Employee Access Date
001 2007/10/01
001 2007/10/02
001 2007/10/03

Using a query i can then check to see if the records match. If there is is way to create a query to do this, it would also solve my problem

[Rabbit]

Query's possible. But it'd be convoluted and difficult. I think it'd be easiest to do it through VBA. But that's slow if you have a lot of records.