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
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