In a report, how to show vertical values horizontally?

[Guest]

Using query, i can create a report showing the values vertically. However, I
need to show them horizontally. An example is below:

Using report, I get this output

User1 200
User1 100
User1 50
User2 150
User2 75
User2 25

What I need is

User1 200 100 50
User2 150 75 25

(values in descending order)

Any ideas?

 

[Guest]

Base your report on a crosstab query.
create the query using the crosstab wizzard, based on the table/query you
are currently using as a source for your table, then vbuild a new table
based on the crosstab.

Rosco

 

[Douglas J. Steele]

See whether you can modify http://www.mvps.org/access/modules/mdl0008.htm at
"The Access Web" to meet your requirements.