In a report, how to show vertical values horizontally?

J

jsccorps

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?
 
R

Rosco

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
 
Top