Results 1 to 2 of 2
  1. #1
    sanbhau is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2016
    Posts
    7

    fixing number of records per page in a report


    There is a report that shows purchase done by different customer in a particular month. The Report is grouped by coustomer id. when i am taking a print out it is happening that purchase by a customer is spreading in two pages. Suppose page 1 is showing 5 purchases of customer A, seven purchases of customer B two of customer C and rest three purchases of customer C is spread to the next page. I tried to overcome the problem by changing the margin of the page but failed to do so. Howevr I have obseved that as per the data, records pertaining to five customers can be accomodated in a page. Is there any way to fix the number of customers (Group Header) to a particular value for each page?

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    So you only want a certain number of records to appear for each page of the report? Can you filter the data down to appear like you want?Group that data and have it keep records together on the same page.

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

Similar Threads

  1. Replies: 2
    Last Post: 02-04-2016, 08:13 AM
  2. Display XX number of records per page
    By cactuspete13 in forum Forms
    Replies: 11
    Last Post: 07-19-2014, 05:17 AM
  3. Replies: 8
    Last Post: 08-12-2011, 11:55 AM
  4. Replies: 1
    Last Post: 03-19-2010, 05:17 PM
  5. Replies: 1
    Last Post: 03-12-2009, 09:55 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