Two Column Report Problem

[Pat]

The report I am trying to create is needed to display as follows:

Name
Address
City State Zip

Date Reference Amount Date Reference Amount
xxxx xxxx xx.xx xxx xxxxx
xx.xx
xxxx xxxx xx.xx xxxx xxxxx
xxx.xx


Total Amount xxxxxx.xx

My problem is that the second column starts on a horizontal line with the
name and address instead of under the detail line as needed. What am I
missing in the setup?

 

[Damian S]

Hi Pat,

You aren't missing anything in the setup - it's just the way Access handles
the columns. To get around this, have your main report with the Company
Name/Address etc (with NO COLUMNS SPECIFIED), then in the Details section
have a subreport that shows the data in two columns as required.

Hope this helps.

Damian.

 

[Damian S]

Hi Pat,

Turns out I lied through my teeth in the previous post... (It made sense as
I was typing it, but then I tested it for you and found it not to work -
sorry about that.)

Try moving your company details to the Page header not the group header.
That will sort it out for you.

Damian.

 

[Rick Brandt]

The report I am trying to create is needed to display as follows:

Name
Address
City State Zip

Date Reference Amount Date Reference
Amount xxxx xxxx xx.xx xxx
xxxxx xx.xx
xxxx xxxx xx.xx xxxx xxxxx
xxx.xx


Total Amount xxxxxx.xx

My problem is that the second column starts on a horizontal line with
the name and address instead of under the detail line as needed.
What am I missing in the setup?

In a multi-column report the only sections that do NOT display as columns are
the Page and Report Header/Footers. If you have your name, address, etc. in any
other section then you cannot get the layout you want unless you use a
sub-report for the multi-column part.

 

[Pat]

Thank you all. I have been going nuts with this.
Thanks again,
Pat

 

[Damian S]

Hi Rick...

I too thought that a subreport for the multi-column part would work, but it
doesn't... is there something special I need to do to make it work, or is it
just another undocumented feature in Access???

D.

 

[Rick Brandt]

Hi Rick...

I too thought that a subreport for the multi-column part would work,
but it doesn't... is there something special I need to do to make it
work, or is it just another undocumented feature in Access???

Multi-column subreports have to be set up as Across, Then Down columns. Down,
Then Across only works if the subreport control has CanGrow set to No.