How do I make columns on a report?

S

Sue

I have a fairly long list of dates that take up a great deal of space. If I
can display them in columns, it will make me very happy because I won't be
killing trees. How do I do it?
 
F

fredg

I have a fairly long list of dates that take up a great deal of space. If I
can display them in columns, it will make me very happy because I won't be
killing trees. How do I do it?
Click to expand...

Are you trying to deprive hundreds of lumberjacks and paper mill
employees their means of support and send their families into welfare?
:-(

In Report Design View, Click on File + Page SetUp + Columns.
 
J

John Spencer

Uh! Sue he did in the last line of his post.

Did you need more detail on exactly how to do this?

--Change Number of Columns to 2 or 3 or 4
--Change Column size to some size 3, 2, 1.5 that will allow that many columns
plus the spacing to fit on the page
--Set column layout to whichever way you want. If this is a subreport, you
will have to use Across then down to get the multiple column effect.
--Click OK


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
S

Sue

What if I only want columns in a section - I have names that have strings of
dates of service, and only want the service dates to be displayed in columns.
Can do?
 
J

John Spencer

No. Not that way.

You can use a subreport with multi-columns (across then down) or you can use
some vba code to concatenate the values into one string separated by spaces,
semi-colons, commas, or whatever.

Duane Hookom has a function that you can use.

Quoting Duane Hookom

I use a generic Concatenate() function. The code is listed below with both ADO
and DAO. There are comments regarding which lines to comment or uncomment
based on which library you prefer. Access 97 is mostly DAO while the default
for 2000 and newer is ADO.

See:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16



--
Duane Hookom
MS Access MVP

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

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

Similar Threads

Format column widths from one table to a separate table on same page 1
Excel does not accept text format! 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Need Help with a VBA subroutine 0
How to make scroll bar permanently visible, Word 365 0
Working on birthday "book" for my wife and having layout/editing trouble 0
New computer, how do i move outlook 365 ENTIRELY? 0
How to create portable Excel applications? 2

Top