Loading

How to create a hotel availability by using MS access as DB

Teoh kimliang

I am facing the Problem to create an availability checking to a few of hotel and my main problem was date things because if I created a database and how to track the room available in particular date which can be in the range.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sundaram Subramanian9y ago
In DB Column, You may have a column to specify the Room is booked on that date or not ?. For a range of dates, use between statement in sql. If the rooms are booked between the date range, then do your action.