Hi All,
Hope this is in the right place as I'm a new poster
I'm in the process of making a database for use with hotel reservations and billing.. I've made a form to put new reservations into the table. Here are the relevant fields:
Check-in date
Check-out date
Weekday nights
Weekend (Fri and Sat) nights
The weekend rate for the hotel in question is slightly higher you see. So is there some kind of expression that I can put in the two 'night' fields to calculate the relevant amounts of either Sun-Thurs nights and Fri-Sat nights?
Tom
Hope this is in the right place as I'm a new poster
I'm in the process of making a database for use with hotel reservations and billing.. I've made a form to put new reservations into the table. Here are the relevant fields:
Check-in date
Check-out date
Weekday nights
Weekend (Fri and Sat) nights
The weekend rate for the hotel in question is slightly higher you see. So is there some kind of expression that I can put in the two 'night' fields to calculate the relevant amounts of either Sun-Thurs nights and Fri-Sat nights?
Tom