Print next 8 days & info

[skippernick]

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

• Guest Name
• Room #
• Transportation
• Departure Date
• Notes

Row 2: Guests Departing

• Guest Name
• Room #
• Transportation
• Notes

Row 3: Guest "In-House" (already here)

• Guest Name
• Room #
• Departure Date
• Notes

The guests can be in 3 or 4 columns from there. Anyone have any idea how to do this?!

Thanks so much!

-Nick

[SoftwareMatters]

This sounds like you want 3 reports in 1.

I would break this down to start with. So:
1. Create a seperate query with all the data that you need for each section of the report.
2. Use the report wizard to create 3 reports based on your queries.
3. Create a master report and add the other reports as subreports.
4. Add 2 textboxes on your form called start and end and format as dates (these will form the filter).
5. In your queries on the date field add the criteria that points to the start and end dates. Something like this: >=forms![Form Name]!start And <= forms![Form Name]!end.
6. Add a button on your form to open the master report.
7. Fill in the start and end dates on your form and then click the button to open the master report.

[skippernick]

JD,

I have not one clue what any of that means. I'm semi-computer savvy, but have only used Access for a hot second. Would there be any way for you to create a draft of this that I can manipulate and toy around with? We are currently using Excel, which just crashed for the third time this week alone. It's getting rediculous.

Anyone else able to help as well?