Add a row to my report help PLZ!!

[mrgreen]

Hi All, I've never messed with Access Reporting but it seems cool if you understand it. I don't! I have approximately 20 or so fields to report. I'm grouping by Date, Product Line, and Shift, and Product and since there are so many columns it stretches across 3 pages. How can I get my report to display 10 columns at the top and 10 at the bottom? All this data is in one query. Thanks for the help.

 

[vbaInet]

If it's stretching across 3 pages then I don't think there's much that can be done.

You can reduce the size of the font of each control and make them tightly fit next to each other. Also, change the orientation of the report to Landscape.

 

[mrgreen]

Hi VBAInet,
I've done that already (reduced font). I've even created a subreport that would contain the second set of information. I just thought there would be an easier way to do this and have it look nice.

 

[vbaInet]

You said, you have reduced the font but you didn't mention if you've changed it to landscape? What font size did you use?

If you need to show 10+ columns it seems to be too much information for one report.

 

[mrgreen]

Sorry, yes I did make it landscape. Font size was 8, so it's already pretty small. I have made a subreport, but thought there was an easier way. Thanks for the help! At least I know there wasn't something I was missing.

 

[vbaInet]

If you're keen on getting all on there, you could consider putting the other 10 fields below and putting a line at the bottom so that demarcates every record.

 

[gemma-the-husky]

another idea - export it as a spreadsheet, and manage it from there