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