[Last Call] Learn how to a build a cloud-first strategyRegister Now


Create report in a horizontal format

Posted on 2006-05-01
Medium Priority
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
  • 3
LVL 54

Expert Comment

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

LVL 54

Expert Comment

ID: 16576358
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

ID: 16577221

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

ID: 16577405
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

nico5038 earned 2000 total points
ID: 16577791
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

834 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