I am wondering if the following query and report is possible?
Again this is from the Hotel Reservation system. Each reservation record has a hotel, an indate and an outdate + a number of rooms. Many of those reservations have an indate in one month and an outdate in another. I need to be able to produce a report that shows the total number of rooms sold for every day in each month. I know that I can do it by creating records (in a related table) for every day in between the in and outdates but is it possible to do this without creating the extra table and records?
TIA