I have designed a report in Access 2007 that shows table data in columns and rows. I have only 4 columns though. That leaves lot of space on right and left of page. I want to utilize more space on one page. Can I repeat the columns on same page? In other words, It will look like this
Col1 Col2 Col3 Col4 Col1 Col2 Col3 Col4
This way, I can fit double the records (rows) on one page.
1) Choose Page Setup, Page Setup to display the Page Setup dialog box.
2) In the Print Options tab, make note of the left and right margin widths, as given by the values in the Left and Right text boxes.
3) Display the Columns tab.
4) In the Grid Settings group, use the Number of Columns text box to type how many columns you want to use in your report.
Do you know how would I use summation function in report. For example, If I want to show total number of female in one columns and total number of males in another column from a table column that stores all males as M and Females as F with each having unique Id associated to it.