I want to make multi columns in an access report

[banger]

Can anyone tell me how to make multi columns in an access report please. I have tried using page set up but that just mess the data around. I want seperate columns for the groups.
Thanks.

 

[KenReay]

Hi

From your brief description, not sure what your problem is, but you mention 'Groups' should you not be looking at sorting and Grouping rather than columns? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[Knicks]

I think I know what you are trying to do. You need to use the Column feature in the page setup of the report. Then on your report right mouse click on the grouping header and goto properties/format. Where it says New Row or Column set to either Before or After....try messing around with that.

Also keep all your fields on the left hand side of the report and within your width setting set in the page setup columns. Be careful with setting fields/subreports to Can Grow, this is fine if fields are below each other but if they are left or right they can make for ugly printing.