Across the Page

[TeeSee]

I can print monthly values (grouped by month in a single field) down
the page. Is it possible to have them print across the page?

 

[Guest]

You can set your Page Setup to print columns across then down.

 

[Larry Linson]

I can print monthly values (grouped by month in
a single field) down the page. Is it possible to
have them print across the page?

Without more detail on what information you have and what you are trying to
do, it's difficult to give you specific advice. Here are a couple of
possibilities:

1. Crosstab Queries can be used to turn a row into a column, which might do
what you want; Pivot Tables do something similar.

2. At least in Access 2003 and earlier, there is no support for a Pivot
Table in a Report. However, you can create the Pivot Table you want in a
Form, and embed that Form in a Subreport Control. (Subreports can contain
either a Report or a Form; Subforms can only contain a Form, not a Report.)

Larry Linson
Microsoft Access MVP