Hey guys, I am creating an online booking system for the ski lodge for which i am a member. Basically I am having problems with bed availability. Basically I don't want people making bookings when there are no beds left in the lodge.

There are 43 beds in the lodge and everytime a booking is made i want the beds to reduce from the total of 43 available for that date.

Obviously if there was a booking for 3 people for 2 nights, where the customer arrives on the 1st of August, the 1st, 2nd and 3rd of August would have to be updated where 40 beds exist, not 43.

Obviously once the beds get to zero on a particular date, a booking cannot be made.

I already have forms where a user submit data into this database:

Table: Bookings
Field: Booking No
Field: DateArrive
Field: DateDepart
Field: NoPersons
Field: NoNights

Thanks everyone

Simon

Just run a query against datearrive and datedepart and nopersons. If the date that you want to book has more than 43 then you can you can not book a room.

Another way would be to have a separate table with with datestay + # people and then each time someone is staying update the table with # people and date.

You can then run a query to count the number of people for that date. Once they have left delete the record.

The only problem whit this is access will get larger with all the deleting going on. If it is access you're using