Results 1 to 6 of 6
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528

    problem of new pages

    Hello you guys nice day.


    I have a report based on a query, in this query are no addresses for students (city).
    I have a problem which is when you show me the report shows students' addresses sequentially in a single sheet.
    What I want is, for example, students who live in the city (a) the number up to the middle of the paper, I do not want students to supplement the city Information (b) on the same page, I want to access lists of who opens a new page for the city (b).
    any help
    Thanks very much .

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Sorry, don't understand any of that.

    What do you mean by 'no' addresses?

    What do you mean by 'up to the middle of the paper'?

    What do you mean by 'students to supplement the city information'?

    What do you mean by 'want to access lists of who opens a new page'?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528
    thank you June7
    What I mean is when there is another city is going to a new page
    Click image for larger version. 

Name:	2211.JPG 
Views:	5 
Size:	47.5 KB 
ID:	22321

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    You want new page for each city?

    Use report grouping. Set up grouping on Region and City. Set it to force a new page after each City group.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528
    Yeah June7 new page for each city
    But how is it possible that example or video

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Do you know how to use report Sorting & Grouping feature?

    Select the group section and set ForceNewPage property.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. additional pages
    By snoopy in forum Reports
    Replies: 3
    Last Post: 06-15-2012, 02:06 AM
  2. Report pages
    By combine21 in forum Reports
    Replies: 1
    Last Post: 03-05-2011, 04:39 PM
  3. Web Pages
    By luizap in forum Access
    Replies: 1
    Last Post: 07-28-2010, 03:58 PM
  4. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM
  5. pages
    By hokie in forum Reports
    Replies: 0
    Last Post: 07-16-2009, 10:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums