Format report from columns to rows 1

[PJFry]

I have a report that currently reads in a column format and I want it to read in a row format.

Forgive the kindergarten explanation, but here is what I am looking to do:
Current format-
1 5
2 6
3 7
4 8

Desired format-
1 2 3 4
5 6 7 8

What is the best way to do this?
Let me know if any clarification is needed.

Thanks!
PJ

 

[dhookom]

I would set up a multiple column report that in your sample would be 4 columns that display across.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]