Trying to sort data into multiple columns on the report.

  • Thread starter Hoardling1 via AccessMonster.com
  • Start date
H

Hoardling1 via AccessMonster.com

Access 2007 I have 1 data column that I want to get on a report, but I want
it to break into two/three columns like so and have some space inbetween the
columns:

1 7 13
2 8 14
3 9 15
4 10 16
5 11 17
6 12 18

The reason is this is a single checklist for people to fill out and multiple
pages is unacceptable. The list will be printed.

Thank You.
 
M

Marshall Barton

Hoardling1 said:
Access 2007 I have 1 data column that I want to get on a report, but I want
it to break into two/three columns like so and have some space inbetween the
columns:

1 7 13
2 8 14
3 9 15
4 10 16
5 11 17
6 12 18

The reason is this is a single checklist for people to fill out and multiple
pages is unacceptable.


Have you tried to use the File - Page Setup - Columns
options for the report (in design view)?
 
H

Hoardling1 via AccessMonster.com

Yes, exactly what i was looking for.
Thank You.

Marshall said:
Access 2007 I have 1 data column that I want to get on a report, but I want
it to break into two/three columns like so and have some space inbetween the
[quoted text clipped - 9 lines]
The reason is this is a single checklist for people to fill out and multiple
pages is unacceptable.

Have you tried to use the File - Page Setup - Columns
options for the report (in design view)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top