Hi everyone,
This is a pretty straightforward problem but I can't seem to wrap my head around it. I'm pretty much a noob when it comes to Access so bear with me!
I've got a simple database for a hotel room booking system with 3 tables as below:
tblCustomer:
CustomerID
Forename
Surname
etc
tblBooking:
BookingID
CustomerID
RoomID
BookingDate
tblRooms:
RoomID
RoomNumber
RoomType
RoomCost
The requirements of the system are pretty basic, each customer who makes a booking only stays for one night at a time in one room.
What I'm trying to do is set up a way for the user to specify a date, and then have the system return which rooms are free (unbooked) on that date.
I've got some idea that I need to use a query to do this. I understand how to get it to show me rooms which are booked on that day, just not rooms which are NOT booked on that day.
I've been banging my head against a wall on this one, can someone please point me in the right direction?
Thanks!