Report Format Help Please

[Guest]

I have a table with for example the following information:

NameID
LastName
FirstName

When I print the report it shows as follows:

1
Smith
Joe
2
Jones
Dave
3
Doe
Jane

What I am trying to get is the following:

1 2 3
Smith Jones Doe
Joe Dave Jane

All on the same report. Even if I have to export to Excel
to get to this state. Not sure what settings in a report
I can set up to make it print this way or get viewed this
way and would appreciate any assistance.

 

[Allen Browne]

Open the report in design view.
From the File menu, choose Page Setup.
Specify the number of columns you want.

Be sure to make the report narrow enough that Access can print the desired
number of columns across the page, after allowing for the left and right
margins.