Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Access 2003 Double Bookings
Name: Jarry1 Date: October 14, 2008 at 09:22:52 Pacific OS: N/A CPU/Ram: N/A Product: N/A
Comment:
Hi, I'm making a system for a Hotel, where I want it to be impossible to double book a room. A 'Room Table' contains the rooms, which are numbered. This is linked to a field in the 'Booking Table' which contains a RoomBooked field, and StartDate and EndDate field. I want it to validate the start and end dates so that any date between them (i.e. of someone's stay) is not inside the dates of any previous bookings, if there room numbers are the same (i.e. both bookings are for the same stay). What should I do?
Name: wizard-fred Date: October 18, 2008 at 15:48:52 Pacific
Reply:
This would waste some space. Use a room file with a day field for every day during the period you want to protect. Flag the field for the reserved days during the period when a reservation is made. When checking availability you have to check every day from proposed start date to proposed end date. Probably by looping. You would probably need a window of date ranges of at least two years.
Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time ([EndTime]-[StartTime])*24 which gives me the dif...
Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I have a table of Assets called tblAssets, im trying ...
Summary: Our agency maintains a Paradox 9 security database. Within this database is table (with 1311 records) which contains demographic data for all employees. One of the fields on this table is BLOB field...
0 
