Search results

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...

If Me.Day <> Me.Till Then GoSub Calc1 Else DoCmd.RunMacro "M_Roombooking", 1 DoCmd.RunMacro "M_Vernieuwen", 1 End If Exit Sub Calc1: DoCmd.RunMacro "M_Roomsfree", 1 Return The meaning is that the Macro "M_Roomsfree" repeat himself as long Me.Day <> Me.Till. In this case the macro repeat himself...

How to make a query where de first value is 0, the next line 1, the next line 2, ...?

Is it better to have a lot af tables for data or 1 tabe for all data?

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...