Recent content by JohnOwens111

raskew. 1. GaryPanic, that method would require a default entry for every room for every date from now until the end of time (or as far as time extends in access) since each room is in a not booked state for every date possible until someone books it. And if that hotel system in the sample was...

The problem is that there are no records for rooms which do not have a state <> 1. Basically, i have a table called tblRoomState which only will have a roomID in it, if there is a booking for that room. There is no record of state in the tblRoom table. So first i need to create a set of "booked...

Hi Everyone, hope someone out there can figure this one out. I am developing an access database and forms based on a hotel booking system. There is a tblRoomState table, which holds the roomID, the date and the state of the room, (so for a 3 night stay, this table holds three entries). I have...