Results 1 to 6 of 6
  1. #1
    kareem_h is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2010
    Posts
    3

    show 4 records in each report page

    hi all.
    i have a table for user data simple data (name, Tel, and ID)
    i want to print them each 4 records in page like this


    is there any way to design the first table in the report and generate every 4 in one page?
    thanks

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    you can adjust the section height and paper height to fit 4 record in each page.

  3. #3
    kareem_h is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2010
    Posts
    3
    you can adjust the section height and paper height to fit 4 record in each page.
    not work for me.
    the idea is to separate the page layout to 4 area an repeat the first design in each one for each record.
    is there any tutorials or examples related to this ?

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    I could not see you picture. But I think you meant that you want to put more than 1 record in one row, right?

    maybe you can try to place subreports side by side, modify the data source to make the subreports have right records.

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I think that weekend's method would work, with the additional step of setting up 2 columns in Page Setup. In your detail section, you would only see one instance of the label. The column setup would repeat one across, and the detail section repeating would get the second line. As weekend suggested, you can adjust the detail section and paper to get 4/page, or creating a labels report would work.

    Weekend, the picture is like 4 labels, 2 rows and 2 across.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    kareem_h is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2010
    Posts
    3
    thank you pbaldy & weekend
    that works.
    very powerful

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

Similar Threads

  1. Page break on report inserts empty page between
    By Galadrielle in forum Reports
    Replies: 0
    Last Post: 07-07-2010, 04:18 AM
  2. Replies: 1
    Last Post: 05-22-2010, 08:30 PM
  3. Moving through records via Page Down
    By Robert M in forum Programming
    Replies: 4
    Last Post: 07-28-2009, 09:21 AM
  4. Lookup or list field: how Do I not show all records
    By scott munkirs in forum Forms
    Replies: 4
    Last Post: 04-13-2006, 12:44 PM
  5. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08:51 PM

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