I'm in the middle of doing a piece of coursework for my ICT GCSE and it involves using Access. I am designing and implementing a datbase that stores customer information and room information in a hotel.
My problem is that I need to do something that sounds quite complecated (well, to me it does!).
During the data collection of a customers details, I will collect the dates which they will stay from and to, and the room number. Say for instance, room 2 was booked for 23rd to the 25th of September, and someone wanted it for the 24th. How would I get the database to tell me that room 2 was already booked?
Do I have to build some sort of complecated expression?