Columnar report for several credit unions

[Diana]

Hello!

I have a query that selects information for 6 credit unions from seveal NCUA
tables. I want to create a columnar report that shows the credit union
information side by side for comparison. For instance:

CU Name DCECU CFCU TDECU MSUFCU ECU SOCU
Assets $xxx $xxx $xxx $xxx
$xxx $xxx
Total loans $xxx $xxx $xxx $xxx
$xxx $xxx
et cetera

I cannot figure out how tho get the data into side-by-side columns. I
created a report with 6 columns of detail, but only the information for the
first credit union shows up. How do I specify that I want each cu number in
a separate column, not on a separate page?

Any help is greatly appreciated.

Thanks!

Diana

 

[Duane Hookom]

Did you use the report layout to create multiple columns? Is it set to print
across then down?

 

[Diana]

Duane -

Thanks for the quick reply. I had already set the number of columns to 6
and chosen across then down in page setup. The report displayed with three
columns to a page and all of the information for the first credit union was
on the first 3 pages. I want information from all 6 credit unions on each
page, like a tabular report in a columnar format. The columns will all have
the same fields for different CUs. Can you give me any more direction?

Thanks for your help.

Diana

 

[Duane Hookom]

Try this Knowledgebase article on multiple columns with labels on the left
http://support.microsoft.com/default.aspx?scid=kb;en-us;210044&Product=acc.

 

[Diana]

Hi, again, Duane!

I read this article, set up an event procedure in the detail section and set
most of the other properties as described. However, I cannot set the width
property of the report to 2". The smallest I can set it to is 8.9583". The
labels print on the left where they belong and the data prints all the way to
the right.

Is there another property I need to change in order to be able to reduce the
width? The article is for Access 2000 and I have Access 2003. Does that
make a difference?

Thanks for all of your help, Duane.

Diana

 

[Diana]

Hello, Duane!

I actually got 7 columns to print on the report! However, when I use
labels, I get 6 columns of labels and 1 column of data. When I omit the
labels, I get 6 columns of data. I believe this is related to the fact that
I cannot set the report width to 1.5". Since the width is 8.9", there is
enough room to print 6 columns of labels, using the OnFormat event procedure
because Left is less than 8.9" 6 times. If I can't change the width of the
report, is there another way around this?

Thank you so much for the help so far.

Diana

 

[Duane Hookom]

You keep saying you can't set the width to less than 8.9". The column width
doesn't have to be the same as the report width.

 

[Diana]

Hi, Duane!

In the article you referred to, I believe the printing of labels is
predicated on the width of the report. The article says to set the report
width to the column width. However, I changed the event procedure to If
Me.Left < 1400 Then... print the labels and I changed the column layout to
Across, then Down, instead of the Down, then Across in the article. This
works! I'm so happy!

Thanks for your help!

Diana