Dates between first and last date

[PeterKegels]

If i have a table with firstdate and lastdate, then i need a query were i can see all the dates between.
Firstdate: 16/05/2013
Lastdate: 23/05/2013

Need result in query:
16/05/2013
17/05/2013
18/05/2013
19/05/2013
20/05/2013
21/05/2013
22/05/2013
23/05/2013

Someone can help me with this?
Many thx
Peter

 

[pr2-eugin]

Peter, First Welcome to AWF..

Your description matches something like Overlapping Records.. See if that helps.. Post back if I have got your requirement wrong..

 

[PeterKegels]

Dear Paul,
Many thx for your fast reply.
I have a lodge at The Gambia and need a booking system.
A client booked a room from 23/05/2013 and will left again on 26/03/2013.
Then i need all the dates between to book them in an other tabel (booked rooms).
Like:
Room 14 booked on 23/05/2013
Room 14 booked on 24/05/2013
Room 14 booked on 25/05/2013
Room 14 booked on 26/05/2013

I have got realy no idee how to handle this.
Many regards.
Peter