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 i book only start and enddate, but there is a query where i casee all the dates between, then problem solved. Room 12 06/05/2013 Room 12 07/05/2013 Room 12 08/05/2013

If someone is booking a room form 01/05/2013 till 16/05/2013 then i realy need a query where a can see all the dates between 01/05/2013 and 16/05/2013. If y see only the start and enddate then it is very possible that we will book the same room for excample from 06/05/2013 till 08/05/2013. If i...

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

If someone book a room at my hotel for several days, then i need a table whit te specific data. For example: Client a book a room from 16/05/2013 till 19/05/2013, then i need a table whit following information: Room 13 Day 16/05/2013 Room 13 Day 17/05/2013 Room 13 Day 18/05/2013 Room 13 Day...

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?

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

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