Results 1 to 2 of 2
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670

    Help With Report Set-Up

    We receive data in a spreadsheet that is auto-imported into access in a garbage format, but this is how we receive it.



    I have been tasked with now creating a report that will show the data. with the shipping information in the header, and in the detail, have the item, measurement and description. Have it display stacked on top of each other like this
    Click image for larger version. 

Name:	2020-04-20_12-37-33.png 
Views:	12 
Size:	3.1 KB 
ID:	41626

    but for some reason when I create the report it adds LOTS of space between each row.

    Then when I convert it to pdf it puts ONE item/measurement/description on ONE page. What I'm after is ONE page per locale with the item/measurement/description stacked like I have in the image.

    I am attaching a database to illustrate.

    Test.accdb

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Shrink the detail section, move the labels, add page break:

    Click image for larger version. 

Name:	page.png 
Views:	12 
Size:	25.4 KB 
ID:	41629

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

Similar Threads

  1. Replies: 16
    Last Post: 03-13-2018, 05:24 PM
  2. Replies: 9
    Last Post: 07-03-2017, 11:24 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