help on generate a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am a fresher here and now meeting a problem when designing a report

I want to let the results shown in rows instead of in columns. Anyone could help me do this? For example, in the table, two columns ar

A1 B
A2 B
A3 B

When the report is genereted by default, it show

A1 B
A2 B
A3 B

However, I want them to be shown as

A1 B1 A2 B2 A3 B3

Can anyone help me out? It is really urgent. Thanks a lot for your help in advance
 
Check out the multicolumn property of the report. (File | Page Setup |
Columns tab)

It can be used to have data displayed in more than one column (the default
that you see is single column) and you can achieve the ability to have
multiple records displayed in a horizontal manner. In your example, you'd
want to set the column number to 3.

--
Ken Snell
<MS ACCESS MVP>

will said:
Hi, I am a fresher here and now meeting a problem when designing a report.

I want to let the results shown in rows instead of in columns. Anyone
Click to expand...
could help me do this? For example, in the table, two columns are
 
Thanks. I have tried that. But it didnot work, because there is another grouping variable in the table. The format was changed to a mess after multi-columned. In the "general question" forum, some suggested to use VBA. But I donot have any background on that. :-
Can sub-report do it? I read some references. But I have not found any useful yet. :-(
 
If you can identify a selection criterion that will give you every third
record (for example), and to start with a different record for each
subreport, then using subreports might be the answer. It would totally
depend upon how well you can set up the proper recordsource query for each
subreport.

--
Ken Snell
<MS ACCESS MVP>

will said:
Thanks. I have tried that. But it didnot work, because there is another
Click to expand...
grouping variable in the table. The format was changed to a mess after
multi-columned. In the "general question" forum, some suggested to use VBA.
But I donot have any background on that. :-(
Can sub-report do it? I read some references. But I have not found any
Click to expand...
useful yet. :-(
 
Thanks. I am not sure if it works. I will try it tonight.

This problem comes from a reference management. I have two tables, one is publication table, including PubID, title. The other is an author table, inlcuding PubID, autherID, surname, first name, order(which means if the auther is the first, second, third.... auther.

Now I want to generate the reference. So the form should be author1, auther2, auther3,..autherN, title. But after grouping, the form of the report is like
Author1
Auther2
...
title(PubID as group variable)

I have no idea how to change it. :-(
 
The other option might be to create a recordset in code (before you call the
report) that concatenates into a single field the field values from
different records (all as a text string), then writes the resulting records
to a temporary table. Then you could use a query based on that temporary
table as the recordsource for the report.

Will take some setting up to do, but it should be more along the lines of
what you seek.

--
Ken Snell
<MS ACCESS MVP>

will said:
Thanks. I am not sure if it works. I will try it tonight.

This problem comes from a reference management. I have two tables, one is
Click to expand...
publication table, including PubID, title. The other is an author table,
inlcuding PubID, autherID, surname, first name, order(which means if the
auther is the first, second, third.... auther.
Now I want to generate the reference. So the form should be author1,
Click to expand...
auther2, auther3,..autherN, title. But after grouping, the form of the
report is like
 
Back
Top