Between Query

[PeterKegels]

I'm booking in my hotel booking system the start and enddate of renting a room.
Excample: Room 12 is booked from (startate) 16/05/2013 till (enddate) 19/05/2013.
Now i need a query where i can see all the dates beween start and enddate.
Like:
Room 12 16/05/2013
Room 12 17/05/2013
Room 12 18/05/2013
Room 12 19/05/2013

This between function i realy need.
Someone a idea how to do?
Many thx
Peter

 

[MarkK]

Is there something wrong with that other thread? Did you check out the link I posted?