awonson
December 4, 2001, 11:34 pm
Hi, I hope someone can offer me some advice.
I have created a database for my school made up of several tables and data entry forms. A union query brings this data together and it is represented on a transcript that is printed for each student in a given year group. This transcript is a report with a subreport. The transcript displays the student's name and then lists the awards and achievements for that student listed under each calendar year.
The main report is made up of Page Header, Detail and Page Footer. The student's first name and surname is found in the Page Header. As a result, their name appears on the top of every page of their transcript along with the school crest. The subreport sections are: Calendar Year Header, Category Header, Detail. The subreport is the union query. The subreport lists all of the awards and other achievements of the student.
How do I place a page number on the bottom of each transcript page that says: "Page X of Y"? This needs to work when the option to print only one student's transcript is selected as well as the option to print transcripts for ALL students in a given academic year (as in one print run).
In this second case, all transcripts would be listed for every student in the year group. The first student's tanscript would have (for example) page 1 of 2 followed by page 2 of 2. Then the next student's transcript would display (for example) page 1 of 3, page 2 of 3, page 3 of 3; followed by the next student.
I was directed to this URL: <a href="http://www.mvps.org/access/reports/rpt0013.htm" target="_blank">http://www.mvps.org/access/reports/rpt0013.htm</a> but when I followed its instructions and entered the suggested code, no page numbers are printed.
I would appreciate any help on this matter.
Many thanks, Andrew
I have created a database for my school made up of several tables and data entry forms. A union query brings this data together and it is represented on a transcript that is printed for each student in a given year group. This transcript is a report with a subreport. The transcript displays the student's name and then lists the awards and achievements for that student listed under each calendar year.
The main report is made up of Page Header, Detail and Page Footer. The student's first name and surname is found in the Page Header. As a result, their name appears on the top of every page of their transcript along with the school crest. The subreport sections are: Calendar Year Header, Category Header, Detail. The subreport is the union query. The subreport lists all of the awards and other achievements of the student.
How do I place a page number on the bottom of each transcript page that says: "Page X of Y"? This needs to work when the option to print only one student's transcript is selected as well as the option to print transcripts for ALL students in a given academic year (as in one print run).
In this second case, all transcripts would be listed for every student in the year group. The first student's tanscript would have (for example) page 1 of 2 followed by page 2 of 2. Then the next student's transcript would display (for example) page 1 of 3, page 2 of 3, page 3 of 3; followed by the next student.
I was directed to this URL: <a href="http://www.mvps.org/access/reports/rpt0013.htm" target="_blank">http://www.mvps.org/access/reports/rpt0013.htm</a> but when I followed its instructions and entered the suggested code, no page numbers are printed.
I would appreciate any help on this matter.
Many thanks, Andrew