How To Snake Columns in an MS Access Report

by George Lawrence J.D.

Microsoft Access, also known as MS Access, is able to collect information from various sources--such as e-mail or data stored on USB and other external devices--and compile that information in detailed and organized reports. When the reports are created, sometimes single columns of data will not do. You need to "snake" the columns. This is not difficult to achieve.


Use the Report Wizard to create a basic report. Open MS Access and select the "Objects" tab in the Database windows. Click on Reports and select "New" from the toolbar. An option to use the Report Wizard will display. Choose to use the Report Wizard.


Choose the table that contains the desired information to be contained in the report and use the Report Wizard to select each field you want to include in the report. This step will vary according to what you need to create the snaking columns for. Select the tables and fields that contain the information you desire.


Finish the Report Wizard and generate a report. Once you have selected the information and finished the Report Wizard, generate a report.


Click "Page Setup" from the file menu and then choose the "Columns" tab. Type in the number of columns you want in the "Number of Columns" box. Click "Okay." Step 3 will generate a report with one column. A snaking report has multiple columns. Following this step will generate multiple columns.


Fine-tune your selections by reducing the width of the controls in the "Group Header" and "Footer" sections, reducing the size of the page margins in the "Page Setup" box, reducing the number of columns, or using the "Landscape" orientation format as opposed to "Portrait" orientation. You have created snaking columns in MS Access; fine-tune the report just as you would any document to make it look presentable (if it does not already).

Items you will need

About the Author

Based in Traverse City, Mich., George Lawrence has been writing professionally since 2009. His work primarily appears on various websites. An avid outdoorsman, Lawrence holds Bachelor of Arts degrees in both criminal justice and English from Michigan State University, as well as a Juris Doctor from the Thomas M. Cooley Law School, where he graduated with honors.

Photo Credits

  • photo_camera Thinkstock Images/Comstock/Getty Images