Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / February 2008

Tip: Looking for answers? Try searching our database.

Report Detail in Two Columns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Supe - 29 Feb 2008 21:40 GMT
I have a report where in the detail section it gives a yearly total from a
Yearly Total query.  The years at total appear as below?

2000    500
2001    600
2002    660
2003    480
2004    555
2005    666
2006    789
2007    987

Is there a way to set it up where it would list the data in two colums like
below

2000    500           2004   555
2001    600           2005   666
2002    660           2006   789
2003    480           2007   987
Golfinray - 29 Feb 2008 21:45 GMT
Go to files/page setup/columns and tell it the number of columns you want and
whether you want them over and down or what. If that does not work change the
properties to columner to tabular.

> I have a report where in the detail section it gives a yearly total from a
> Yearly Total query.  The years at total appear as below?
[quoted text clipped - 15 lines]
> 2002    660           2006   789
> 2003    480           2007   987
Supe - 29 Feb 2008 21:57 GMT
Already had the column set to 2.

Where in properties do I change to tabular?  The report properties?  The
detail properties?

> Go to files/page setup/columns and tell it the number of columns you want and
> whether you want them over and down or what. If that does not work change the
[quoted text clipped - 19 lines]
> > 2002    660           2006   789
> > 2003    480           2007   987
Golfinray - 29 Feb 2008 22:09 GMT
The the section header there is a control called new row or column. Change it
to after section.

> Already had the column set to 2.
>
[quoted text clipped - 24 lines]
> > > 2002    660           2006   789
> > > 2003    480           2007   987
Supe - 29 Feb 2008 22:18 GMT
I changed the New Row or Column to After Section in the Details section
properties.  Now it lists on new year on a new page, but only the odd
numbered years????

> The the section header there is a control called new row or column. Change it
> to after section.
[quoted text clipped - 27 lines]
> > > > 2002    660           2006   789
> > > > 2003    480           2007   987
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.