|Rating(1-10)||Knowledgeability = 10||Clarity of Response = 10||Politeness = 10|
|Comment||Scott, with your advice and widom, I have emptied my TblBookings of 25,000 plus records! I add records to TblBookings for every date between Check-In date and Check-Out date, less the Check-Out date - to make the room available again on Check-Out day. I also create matching records in TblBookedDates. Here is your suggested code that I modified to ensure that there are no clashes (for future reference for other users, the "paying-it-on" system that AllExperts encourages :) SELECT TBLRooms.RmNumber, TBLRooms.RmCode FROM TBLRooms WHERE (((TBLRooms.RmNumber) Not In (SELECT RmNumber FROM tblBookedDates WHERE StayDate >=[ENTER CHECKIN DATE] and StayDate <[DEPART DATE]))); Many thanks mate, a great opportunity taken (problem solved) - I don't have problems anymore, just opportunities|
Answers by Expert:
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Brooklyn College BA