Sarah-
That expression looks fine, but it might not like the fact that you put it in the group footer instead of the page footer. Also, that won't get what you want because [Pages] is the total count of pages for the entire report, and [Page] gets incremented with each new page, not each group. You can write some code to reset the Page property to 1 in the Format event of the Group Header - simply say:
Me.Page = 1
If you want an accurate count of the pages in a subgroup, you'll have to do the counting yourself in code and set an unbound text box to what you want to display.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Apr 16, 2015, at 12:44 AM, sarahk@schemesoftware.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Is there any way to print 'page n of n' based on a sub-group of an access report, instead of based on the complete report?.
for example: I am printing report cards for an entire class , sorted and grouped by name. A report card can span multiple pages, is there a way to print 'page n of n' in the footer for the individual report card. So that a student would get page 1 of 2 and 2 of 2 on their report card?.
I tried to insert a textbox in the name footer ="Page " & [Page] & " of " & [Pages], but the report does not run at all, just say 'formatting' ,but it is 'frozen'.
Is there any way I can do this, so that I dont have to print each report card individually.
Sarah
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar