A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Snakeing Sub Report



 
 
Thread Tools Display Modes
  #1  
Old March 9th, 2010, 11:23 AM posted to microsoft.public.access.gettingstarted
Mervyn Thomas[_2_]
external usenet poster
 
Posts: 30
Default Snakeing Sub Report

I have a members database with people divided into groups or categories etc.
The report I am trying to do is have many columns at the group header level
with only one field - the fullname of all those members in the detail
section for that group. What I would like to have is this information
is snaked through about 3 columns in this detail section. Is there any
way of doing it? Could it be a macro? Except I cannot think how to go
about it!


  #2  
Old March 9th, 2010, 02:17 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default Snakeing Sub Report

In a sub-report you can have multiple columns but you must use across then
down layout and not down then across. If that does not solve your problem
then you are going to need some complex coding to identify which records go in
column 1, 2, and 3. You would still need to used the across then down setup.

To set up multiple columns, you use page setup. Found under the File menu in
versions of Access prior to Access 2007.

Hope this helps solve your problem.

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

Mervyn Thomas wrote:
I have a members database with people divided into groups or categories etc.
The report I am trying to do is have many columns at the group header level
with only one field - the fullname of all those members in the detail
section for that group. What I would like to have is this information
is snaked through about 3 columns in this detail section. Is there any
way of doing it? Could it be a macro? Except I cannot think how to go
about it!


  #3  
Old March 9th, 2010, 06:23 PM posted to microsoft.public.access.gettingstarted
Mervyn Thomas[_2_]
external usenet poster
 
Posts: 30
Default Snakeing Sub Report

I guess I would need to get the multiple columns into a subreport and then
insert this into the main report which can only handle one column. I am
not too sure how to accomplish this in practise!

"John Spencer" wrote in message
...
In a sub-report you can have multiple columns but you must use across then
down layout and not down then across. If that does not solve your problem
then you are going to need some complex coding to identify which records
go in column 1, 2, and 3. You would still need to used the across then
down setup.

To set up multiple columns, you use page setup. Found under the File menu
in versions of Access prior to Access 2007.

Hope this helps solve your problem.

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

Mervyn Thomas wrote:
I have a members database with people divided into groups or categories
etc. The report I am trying to do is have many columns at the group
header level with only one field - the fullname of all those members in
the detail section for that group. What I would like to have is
this information is snaked through about 3 columns in this detail
section. Is there any way of doing it? Could it be a macro?
Except I cannot think how to go about it!



  #4  
Old March 9th, 2010, 08:35 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default Snakeing Sub Report

Do you really need a sub-report to do what you want? I can't tell from your
description. I only proposed doing this in a sub-report because of your
subject line.

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

Mervyn Thomas wrote:
I guess I would need to get the multiple columns into a subreport and then
insert this into the main report which can only handle one column. I am
not too sure how to accomplish this in practise!

"John Spencer" wrote in message
...
In a sub-report you can have multiple columns but you must use across then
down layout and not down then across. If that does not solve your problem
then you are going to need some complex coding to identify which records
go in column 1, 2, and 3. You would still need to used the across then
down setup.

To set up multiple columns, you use page setup. Found under the File menu
in versions of Access prior to Access 2007.

Hope this helps solve your problem.

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

Mervyn Thomas wrote:
I have a members database with people divided into groups or categories
etc. The report I am trying to do is have many columns at the group
header level with only one field - the fullname of all those members in
the detail section for that group. What I would like to have is
this information is snaked through about 3 columns in this detail
section. Is there any way of doing it? Could it be a macro?
Except I cannot think how to go about it!



  #5  
Old March 10th, 2010, 07:24 PM posted to microsoft.public.access.gettingstarted
KenSheridan via AccessMonster.com
external usenet poster
 
Posts: 1,610
Default Snakeing Sub Report

The demo file at the following link might help:

http://community.netscape.com/n/pfx/...apps&tid=24271


Its simplified as it was produced purely in response to a reader's enquiry to
a contact of mine who wrote a databases column in a magazine, but it should
give you the general idea. In this case the people are grouped by address
rather than category, but the principle is the same.

The file includes both a single report and a subreport solution. The latter
would probably suit you; the first manipulates the layout of the report in
code at runtime and was only produced because the reader in question
specifically wanted to know how to do this. While it gives the same result,
using a subreport is far simpler.

Another thing you'll notice is that each person has an FP (family position)
value by which they are sorted in the subreport. Again this was in response
to the reader's specific requirement and is not an intrinsic part of the
solution.

A similar layout could be produced with a single multi-column report, but the
group value (the address in my demo) would be above the people's names rather
than to their left. Using a subreport means it can be positioned to the
right of the address, so the first row of names is on the same line as the
address, as was wanted by the reader in this case.

Ken Sheridan
Stafford, England

Mervyn Thomas wrote:
I guess I would need to get the multiple columns into a subreport and then
insert this into the main report which can only handle one column. I am
not too sure how to accomplish this in practise!

In a sub-report you can have multiple columns but you must use across then
down layout and not down then across. If that does not solve your problem

[quoted text clipped - 19 lines]
section. Is there any way of doing it? Could it be a macro?
Except I cannot think how to go about it!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201003/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.