next data record positioning

[Sidefly]

I am trying to change where the next record is displayed on a report. For
example, if you had a list of months, it will display as follows:

Jan
Feb
Mar

How do I change the next record to flow to the right verses down? Example:

Jan Feb Mar

Thanks!

 

[Evi]

This looks like a crosstab report based on a crosstab query.
These will work best if you give your months a number (Use Month(YourDate)
and put that as the Column Header. (Your labels can say Jan, Feb etc)

In the Query's design view, click below the white grid, click on Properties
and next to Column Headings type
1,2,3,4,5,6,7,8,9,10,11,12
To turn this query into a report, go to Insert, Report then choose
Autoreport Tabular


Evi

 

[Larry Linson]

I am trying to change where the next record is displayed on a report. For
example, if you had a list of months, it will display as follows:

Jan
Feb
Mar

How do I change the next record to flow to the right verses down? Example:

Jan Feb Mar

If you have few enough records that they will fit on the same line, size the
detail section so that as many sections (with gutter space) will fit within
the margins, then in PageSetup, define columns, and specify "Across then
Down". If you have more records than will fit on one line, they will display
on the next line, as in:

Jan Feb Mar
Apr May Jun

If you only have a single value to display for each detail, then Evi's
suggestion of crosstab is probably good.

Another alternative for Access 2002 or later is to embed a PivotTable Form
as a Subreport.

Larry Linson
Microsoft Office Access MVP