Greetings,
Alright, I work at a hotel, and in my department I need to create an access file that can keep us organized on guest arriving/during their say/departing.
I've got the form set up, and ready, no big deal there. However, I have not one clue how to create the report field. What I need to do is create a button on my form that says "Print Report" they click it, you enter the date range and then the form is autopopulated. I need it to be broken into 3 main rows (see below).
Row 1: Guests Arriving
Row 2: Guests Departing
- Guest Name
- Room #
- Transportation
- Departure Date
- Notes
Row 3: Guest "In-House" (already here)
- Guest Name
- Room #
- Transportation
- Notes
The guests can be in 3 or 4 columns from there. Anyone have any idea how to do this?!
- Guest Name
- Room #
- Departure Date
- Notes
Thanks so much!
-Nick