Adding a page to a report

[bradp1979]

Not quite sure how to describe everything, but I've got a report called Special Event Report Sheet. On this sheet are all of the names of employees that are working an event, and the hours they are scheduled, as well as a bunch of other information. When this report is brought up, it is always brought up in Print Preview mode, with the button to print popping up as well.

I want to add a second page to this report, that has all of the phone numbers of all of the employees who are scheduled to work the specific event.

All of the information for the SERS is currently pulled from frmEvent, and the information I need would be pulled from the "Primary Phone" column of tblEmployee. If Primary Phone is null, then it would pull from the "Cellular Phone" column.

I don't have any idea how to do this. I know that it would have to cross-reference frmEvent to know which employees to pull the information from off of the table, but that's about all I know. I don't even know how to add a page to the report.

Any help would be greatly appreciated.

Thanks.

[rpeare]

Why do you need to add a page instead of just a phone number column?

Then you could just substitute a formula for the phone number something like =iif(isnull([primaryphone]), [CellPhone], [PrimaryPhone]) in an unbound text box on your report, assuming the query driving it also has the two phone numbers in it (or even better you could perform this immediate if statement in the query driving your report just as easily.

[NTC]

Typically with a Report - one has the record source (table or query) and that defines what fields are available to go on the report. So one solution may be to check the field list of the record source. If the fields you want to add are not there then go the record source and alter that.

Once these fields are in the record source they appear in the field list and one just drags them onto the report.

Alternately if these fields are not part of the record source, and cannot be made to be included into the record source - then one must rely on more advanced methods to include them in a report using unbound fields and calls to either open forms or DLookUp methods.

In regard to adding pages; a Report will auto break and add a new page based upon the length of the data itself without the designer needing to do anything. But there is also a page break control - which can be dragged onto the report. This is used to force a new page.