45218 MSAccess Room Reservations ASP

This MS Access database already exists with these fields. With 3 Tables Properties(table) prop_name prop_id Rooms(table) room_id prop_name room_name room_number reservations(table) reservation_id first_name last_name email_add phone checkin_month checkin_day checkin_year checkout_month checkout_day checkout_year occupancy reservation_property room_id This database is accessed by a DSN "RRES". I will need the following 2 scripts/pages created: 1) Property Availability Query I will pass the page querystring variable "r_date=MO/DY/YR" to your script/page. 1a. The query selects all UNIQUE "prop_name" and "prop_id" from properties, then displays a table in the results with each UNIQUE property as a left column. For each property, there will also need to be a room_id for each UNIQUE room of the corresponding reservation_property. 1b. It takes the variable r_date my page passes to it, and queries the database for any reservations on that date AND for that "reservation_property" AND "room_id". IF the date AND reservation_property AND "room_id" has a reservation, then SHOW [login to view URL] in the right column, next to the corresponding name of the "room_id". If the property does not match the date AND reservation_property AND room_id, then show greenimage.gif. (see the attached GIF file for a visual representation of what I am asking here) 2) Add New Reservation page. I can write a straight insert script into the database myself, but I need someone to write a script for handling multiple date insertions. For example, if a person reserves the dates, 10/11 though 10/17, there needs to be 7 records inserted, one for each day. 10/11, 10/12, 10/13, etc. I think we can use the VB script "DATEDIFF" to count the days by comparing the 2 dates, but I do not know how to insert the 7 records, with the same reservation_id. I am pretty good at ASP and can provide you with alot of assistance, I just need someone to make these 2 pieces work smoothly. I know if can be done in a few hours by anyone who knows ASP fluently.