RE: formatting query row data as columns in report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Check Help on creating a crosstab query, and then base the report on this query

"gary" wrote:

> 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
>
.

Relevant Pages