Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

two pages report

Status
Not open for further replies.

cluser

Technical User
Jun 19, 2005
38
US
My report has two pages,I now make them using the same data source, in each page there are texts, also have detail section that shows the fields.

I created the first page, but don't how to create the second page, for the page also has header and detail section.

How can I implement this?

Thanks
 
It is very difficult to picture your problem. Perhaps you need to use subreports inside a main report. (perhaps not)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Here is a layout of my report in MS Word.


********************************************************

[ParentFullNames]
[Address]
[Address2]
[CityStateZip]


Some text here

To access classroom pages, all students, parents, and staff are assigned individually unique log-ins and passwords. Below is your parent/guardian logon/password associated with each child in your household:
[BBStudent1] [BBStudent2]
[BBStudent1GuardianID] [BBStudent2GuardianID]
[BBStudent1GuardianPassword][BBStudent2GuardianPassword]

[BBStudent3] [BBStudent4][BBStudent3GuardianID] [BBStudent4GuardianID]
[BBStudent3GuardianPassword] BBStudent4GuardianPassword]





For added security, please change your Blackboard password(s) to something familiar and known only to you. Instructions to do so are included on the enclosed instruction sheet. On the other side of this form, you will find a log-in and password for Skyward Family Access as well.
More text here.



<b>Following is the second page</b>



Skyward Family Access
Skyward Family Access offers parents/guardians an opportunity to see information stored in our Student Information database for your children. ………………

Students: [SkyStudentOne] , [SkyStudentTwo] , [SkyStudentThree], [SkyStudentFour], [SkyStudentFive], [SkyStudentSix], [SkyStudentSeven]
Family Logon: [SkyParentLogOn]
Password: [SkyParentPassword]



Please log on to Skyward Family Access at your earliest convenience and be sure your information is accurate and that your e-mail address is in the system. For added security and convenience, ……………….
Another of paragraph here.
***************************************************

I have the datasource that every student has a record, then I group by parent1. The [] is the field from the query
How can I create two-page report like above,

Thanks for any suggestions.
 
How are the pages/records related? Is the information you provided all in a single record from one table?

You table structure looks a bit un-normalized.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top