Problems with Multiple Columns Report in Access
Posted on 2013-06-28
Frustratingly I seem to be unable to get multiple columns in Access 2010 to work. I've reviewed tons of posts, downloaded a sample (which works) yet I'm unable to recreate it.
Pretty simple query, spits out 2 fields: Section and Name
Create a extremely generic report, set group by Section. Set colums to something other than 1, tried setting width to various sizes along with changing every other setting on the Columns tab yet when I view the report, it simply puts everything in a giant single column.
Attempted to set the detail and group sections' property New Row or Col, Force new Page, etc to After, Before or Before & After, no change. Changing landscape/portrait, various page widths along with various field widths... 0 change. Forced the source query into a GROUP BY sort, but again no change.
I know it has to be something simple, but I just can't seem to catch it.