Im creating a reservation system. Rather than having 1 price im looking to have multiple prices for different days of the week, and type of rooms etc.
Is there anyway I can get my "rates" on excel file into an access database so that If a customer wants to stay Fri & Sat the system looks for a room then I could search for a rate and the system will extract the rates from a file and give me the average rate. £100 on Friday and £50 on Saturday makes an average rate of £75 per night.
Is there anyway I can get my "rates" on excel file into an access database so that If a customer wants to stay Fri & Sat the system looks for a room then I could search for a rate and the system will extract the rates from a file and give me the average rate. £100 on Friday and £50 on Saturday makes an average rate of £75 per night.
Hotel Rate Table
