Query results in multiple columns

[stevenkeeble]

Morning,

I have a simple report which shows data form a table through a basic query and displays it just as the table view. I was wondering if there is a way to get this information to display in two columns on a page rather than just one list which takes up multiple pages?

Thanks

 

[pbaldy]

In Page Setup you can specify multiple columns.

 

[stevenkeeble]

In Page Setup you can specify multiple columns.

Hi Paul,

I have tried doing this and setting it to two columns but it doesn't make any difference. The subreport on the main report is 11cm wide and when I set the column size to 12 it still just puts the data in one list rather than in two columns.

Sorry, pretty new to Access!

Thanks

 

[pbaldy]

You said a simple report; I'm not sure how a subreport fits into the picture. Can you post the db here?

 

[stevenkeeble]

You said a simple report; I'm not sure how a subreport fits into the picture. Can you post the db here?

It wont let me upload the file, something about security tokens. The layout is just one main report and the detail section of the report has one subform/subreport which returns the data from a select query. I just want this data to display in two columns rather than one continuous one if that makes sense.


Thanks

 

[vbaInet]

It wont let me upload the file, something about security tokens.

Zip the file and upload it.

I just want this data to display in two columns rather than one continuous one if that makes sense.

In the Columns dialog box where you set the column options, ensure that the Width untick the "Same as Detail" box and reduce it to be perhaps 0.5 cm more than the width of the subreport control and open the report in Print Preview (not in Report View).

Once opened in Print Preview, you can play around with the Column settings and it should adjust accordingly.

 

[gemma-the-husky]

to get multiple columns the report can only occupy half the width of the page. The second column then repeats the contents of the first column.

So it's useful for things like telephone directories.

I am not sure about a subreport. Try designing it as a single report to see the effect. Then see if you can add a narrow subreport within the first column.