Thank you for your help I REALLY appreciate people like you who take time to help others. I'm getting closer to the solution now.
However, what do I write in the CDate(??????). How will access know that the date is only the first 8 characters. How will access know that 01062005 is DDMMYYYY...