Create report in a horizontal format

Posted on 2006-05-01
Last Modified: 2010-07-27
I have to create a report in a horizontal format.

Its in this format now:

FY06 Budget  Personnel
cumm_budget Personnel
FY_Proj Personnel
FY06 Budget_Otps

I want it in this format in MS Access

FY06 Budget  Personnel                    FY06 Budget_Otps
cumm_budget Personnel                  Cumm_budget_Otps
FY06_Proj Personnel                        FY06_Proj_Otps

How do I do that?

Thanks in advance


Question by:Kdankwah
    LVL 54

    Expert Comment

    Ddi you try to use File/Page settings.. and then select the columnar setup from the popup form ?

    LVL 54

    Expert Comment

    Oops, forgot to mention that you first need to open the report in designmode.
    The tab "Colomns" holds the field "Number of columns" and when a value >1 is enterd you can specify the direction it will have to show the items.


    Author Comment


    Where is this tab columns.  I am using Access 2003.  I dont seem to find it in my report design.

    By the way, can you run a report out of Access when a file is linked to a Excel.  I would like to update from excel and have a button to run the report out of Access.

    Can it be done?


    LVL 44

    Expert Comment

    When you open the report in design mode, click File, Page Setup.  You can create a report from a table linked to and Excel file.
    LVL 54

    Accepted Solution

    As stated by GRayL, you can create a linked table pointing to an excel sheet. For the Access report there's no difference where the actual data is coming from :-)
    The steps:
    1) Open report in design mode
    2) Select File/Page settings.. from the menubar
    3) Click "Columns" tab in popup form
    4) Type "2" in the "Number of Columns"
    5) Select the "N" fill of the columns.

    Let me know when you have trouble with on of the steps.


    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now