formatting query row data as columns in report

G

gary

I have a query that “always†returns at most, 4 rows. I would like to
present the rows in a report, with the data formatted as columns on the
report. As an example:

From the query…

Row1 data: a, b,c
Row2 data: e, f, g
Row3 data: x, y, z

For the report…

a e x

b f y

c g z

I would appreciate ideas/suggestions on how best to accomplish this.

Thanks, Regards,
Gary
 
D

Duane Hookom

I don't think a crosstab by itself will work. You might need a union query
based on your "From the query" and then create a crosstab based on the union
query.
 
Top