Setting up columns in report view

[viper]

Hi, very new to Access. In report design, how can I get it to display my data in 4 columns and 5 rows?

Right now it shows data like so in the detail part.

5/14/04 114
5/16/04 105
5/18/04 110
5/20/04 106
5/22/04 110
5/24/04 96
5/26/04 111
5/28/04 106

I am wanting it to show the above data in 4 columns w/ 5 rows each like so.

5/14/04 114 5/24/04 96
5/16/04 105 5/26/04 111
5/18/04 110 5/28/04 106
5/20/04 106
5/22/04 110

I will have 20 scores so I need 4 columns w/ 5 rows.

Thanks for any help,

 

[SydneyGeek]

Hi Viper,

you need to do this in 2 places.
1. Multi-column: In the report design, go to Page Setup. Click the Columns tab, and play with the number of columns, their width and spacing. Just make sure that the maths adds up to total page with minus margins... Also, make sure back in Design view that your fields fit into the width of the first column.
2. 5 records per column: I don't know a way to do this as an absolute but you can fudge it. Play with the height of the Detail section to get the line spacing the way you want it. Then adjust the height of the Page Header and Page Footer to limit the number of records that show in a page.

Denis