asked on

Create report in a horizontal format

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
Cumm_budget_Otps
FY06_Proj_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

Kf

nico5038

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

Nic;o)

nico5038

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.

Nic;o)

Kdankwah

ASKER

Nic:o),

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?

Thanks

Kofi

GRayL

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.

ASKER CERTIFIED SOLUTION

nico5038

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial