format to alphabetize down rather than across in columns

[Guest]

For my conference registration db, I need to produce reports listing the
people who have signed up for specific events -- like lunch or a specific
seminar. Using a label approach, I can make the names appear in 3 columns
like I want but the alphabetizing goes across rather than down. How can I
make it go down one column of names and then to the 2nd column and down
again, etc.?

I will appreciate your help.

 

[Jeff Conrad]

in message:

For my conference registration db, I need to produce reports listing the
people who have signed up for specific events -- like lunch or a specific
seminar. Using a label approach, I can make the names appear in 3 columns
like I want but the alphabetizing goes across rather than down. How can I
make it go down one column of names and then to the 2nd column and down
again, etc.?

1. Open the report in Design View

2. Go to File | Page Setup from the main Access menu

3. On the dialog box that pops up go to the Columns Tab

4. In the selection area called Column Layout select "Down, then Across"

5. Hit Ok

6. Close and save the report changes.

Open the report and the names will do down the column and then over
to the next one in alphabetical order.