Column Printing vs Row Printing

[pgoulet]

Access allows for Row printing, with a row heading.

ex:
col1 col2 col3 col4
Jan Feb Mar Apr
Data Data Data Data
Dat1 Dat1 Dat1 Dat1
Dat2 Dat2 Dat2 Dat2


What ideas do you have related to printing the data in column format, currently I am getting the following:
ex:
column1 column2 column3
Jan data Jan dat1 Jan dat2
Feb data Feb dat1 Feb dat2
Mar data Mar dat1 Mar dat2
Apr data Apr dat1 Apr dat2

What I am looking for is:

col1 col2 col3
Jan data dat1 dat2
Feb data dat1 dat2
Mar data dat1 dat2
Apr data dat1 dat2

We currently have several reports (Excel Spreadsheets) that have certain formating used by the various departments. Trying to avoid re-educating the staff in looking at their data and model the report in something they are already familiar with, and for our mission, the way it is displayed best shows the data. All data is currently in various Excel worksheets, that act as the reports. Excel allows for column freezing.

When I tried to do a Pivot Query I am only allowed to put 3 items on the Left side.

Thanks for the help.

 

[BSman]

I create reports like this by using the detail section to capture the data items, but only printing on the grouping level. It works especially well when your data source is a format something like (for example):

item month value

In this example you might want a report to look something like:

item June July August September October
Item value value value value value

In the detail you would have month control and a value control. Based on the value in the month control you would place the contents of the value control in the appropriate control for that month in the grouping level. The grouping would be by item.

You can also create your heading values (in this example the months) by filling in header controls based on a query or a range used to select the data for the query used as the source for the report.

It can take some fiddling around to get it work, but once you get the hang of doing this way it works very well and is actually fairly quick and easy to use and quite flexible.

 

[pgoulet]

BSman, Thanks. I will take another look at the grouping items. Sounds like you have gotten to where I need to go. Thanks again.

Paul