How do I make columns on a report?

  • Thread starter Thread starter Sue
  • Start date Start date
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?
 
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.
 
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
 
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?
 
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
 
Back
Top