Please Help. How do I do this?

  • Thread starter Thread starter confused
  • Start date Start date
C

confused

I am tring to print out basketball stats for my team.
The first "column" is the players name then their stats.
I have to many fields that will fit across the page so...
naturally they are forced onto another page.
I would like to have the fields that don't fit get printed
below the tenth player. The first "column" would show the
players name and then the remaining stat fields.

Name fga fgm f% 2a 2m 2% 3a 3m 3% totpt
andy
art
bart
bob
chris

Rather than being forced to a new page, start printing
again after chris with the player name and new field names:

Name dreb oreb totreb ast blksh
andy
art
bart
bob
chris

Any help would be greatly appreciated. Thanks.
 
Hi,

What you are trying to create is a Horizontal Page break in Access. You
can only implement a Vertical Page break in Access.

As a workaround you may want to try using a subReport in your Report's
Footer. Example:

Main Report prints these columns
Name fga fgm f% 2a 2m 2% 3a 3m 3% totpt

SubReport that resides in the Main Report's Footer prints these columns
Name dreb oreb totreb ast blksh


Now the hard part would be forcing a page break in the main report AND the
subReport. Take a look at ACC: How to Control the Number of Records
Printed Per Page
http://support.microsoft.com/default.aspx?scid=kb;en-us;119075

IMPORTANT: you can't force a page break in a subReport

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

--------------------
| Content-Class: urn:content-classes:message
| From: "confused" <[email protected]>
| Sender: "confused" <[email protected]>
| Subject: Please Help. How do I do this?
| Date: Wed, 25 Feb 2004 09:08:38 -0800
| Lines: 26
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP7wgLl6HIsstgLSzOunZzbe30KUw==
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.reports:131844
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.reports
|
| I am tring to print out basketball stats for my team.
| The first "column" is the players name then their stats.
| I have to many fields that will fit across the page so...
| naturally they are forced onto another page.
| I would like to have the fields that don't fit get printed
| below the tenth player. The first "column" would show the
| players name and then the remaining stat fields.
|
| Name fga fgm f% 2a 2m 2% 3a 3m 3% totpt
| andy
| art
| bart
| bob
| chris
|
| Rather than being forced to a new page, start printing
| again after chris with the player name and new field names:
|
| Name dreb oreb totreb ast blksh
| andy
| art
| bart
| bob
| chris
|
| Any help would be greatly appreciated. Thanks.
|
 
confused said:
I am tring to print out basketball stats for my team.
The first "column" is the players name then their stats.
I have to many fields that will fit across the page so...
naturally they are forced onto another page.
I would like to have the fields that don't fit get printed
below the tenth player. The first "column" would show the
players name and then the remaining stat fields.

Name fga fgm f% 2a 2m 2% 3a 3m 3% totpt
andy
art
bart
bob
chris

Rather than being forced to a new page, start printing
again after chris with the player name and new field names:

Name dreb oreb totreb ast blksh
andy
art
bart
bob
chris
Click to expand...

You need two sets of detail records to do this kind of
thing. It can get a little messy, but here goes.

First, change the report's record source query to something
like this:

SELECT 1 As Batch, [Name], fga As Col2,
fgm As Col3, [f%] As Col4, [2a] As Col5,
[2m] As Col6, [2%] As Col7, [3a] As Col8,
[3m] As Col9, [3%] As Col10, totpt As Col11
FROM thetable
UNION ALL
SELECT 2, [Name], dreb,
oreb, totreb, ast,
blksh, Null, Null,
Null, Null, Null
FROM thetable


Now create a group with heading (and footer for team stats?)
on the Batch field. Place 10 labels in the group header
(after the Name label) for the column headings. Set the
names of thse labels to lblCol2 - lblCol11. Then use code
in the group header Format event to set the column heading
labels for the batch:

Select Case Me.Batch
Case 1
Me.lblCol2.Caption = "fga"
Me.lblCol3.Caption = "fgm"
. . .
Me.lblCol11.Caption = "totpt"
Case 2
Me.lblCol2.Caption = "dreb"
Me.lblCol3.Caption = "oreb"
. . .
Me.lblCol6.Caption = "blksh"
Me.lblCol7.Caption = ""
Me.lblCol11.Caption = ""
End Select

In the detail section bind the text boxes to the field names
Col2, Col3, etc.
 
Hi Marshall,
Thanks. Unfortunately I do not know how to code.
Is there a way without coding?
Thanks.
-----Original Message-----
confused said:
I am tring to print out basketball stats for my team.
The first "column" is the players name then their stats.
I have to many fields that will fit across the page so...
naturally they are forced onto another page.
I would like to have the fields that don't fit get printed
below the tenth player. The first "column" would show the
players name and then the remaining stat fields.

Name fga fgm f% 2a 2m 2% 3a 3m 3% totpt
andy
art
bart
bob
chris

Rather than being forced to a new page, start printing
again after chris with the player name and new field names:

Name dreb oreb totreb ast blksh
andy
art
bart
bob
chris
Click to expand...

You need two sets of detail records to do this kind of
thing. It can get a little messy, but here goes.

First, change the report's record source query to something
like this:

SELECT 1 As Batch, [Name], fga As Col2,
fgm As Col3, [f%] As Col4, [2a] As Col5,
[2m] As Col6, [2%] As Col7, [3a] As Col8,
[3m] As Col9, [3%] As Col10, totpt As Col11
FROM thetable
UNION ALL
SELECT 2, [Name], dreb,
oreb, totreb, ast,
blksh, Null, Null,
Null, Null, Null
FROM thetable


Now create a group with heading (and footer for team stats?)
on the Batch field. Place 10 labels in the group header
(after the Name label) for the column headings. Set the
names of thse labels to lblCol2 - lblCol11. Then use code
in the group header Format event to set the column heading
labels for the batch:

Select Case Me.Batch
Case 1
Me.lblCol2.Caption = "fga"
Me.lblCol3.Caption = "fgm"
. . .
Me.lblCol11.Caption = "totpt"
Case 2
Me.lblCol2.Caption = "dreb"
Me.lblCol3.Caption = "oreb"
. . .
Me.lblCol6.Caption = "blksh"
Me.lblCol7.Caption = ""
Me.lblCol11.Caption = ""
End Select

In the detail section bind the text boxes to the field names
Col2, Col3, etc.
Click to expand...
 
Hi,
Thanks.
-----Original Message-----
Hi,

What you are trying to create is a Horizontal Page break in Access. You
can only implement a Vertical Page break in Access.

As a workaround you may want to try using a subReport in your Report's
Footer. Example:

Main Report prints these columns
Name fga fgm f% 2a 2m 2% 3a 3m 3% totpt

SubReport that resides in the Main Report's Footer prints these columns
Name dreb oreb totreb ast blksh


Now the hard part would be forcing a page break in the main report AND the
subReport. Take a look at ACC: How to Control the Number of Records
Printed Per Page
http://support.microsoft.com/default.aspx?scid=kb;en- us;119075

IMPORTANT: you can't force a page break in a subReport

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03 -026.asp> and/or
to visit Windows Update at
Click to expand...
 
confused said:
Thanks. Unfortunately I do not know how to code.
Is there a way without coding?
Click to expand...


Then I suggest that you use praha's two subreports approach.
--
Marsh
MVP [MS Access]


-----Original Message-----
confused said:
I am tring to print out basketball stats for my team.
The first "column" is the players name then their stats.
I have to many fields that will fit across the page so...
naturally they are forced onto another page.
I would like to have the fields that don't fit get printed
below the tenth player. The first "column" would show the
players name and then the remaining stat fields.

Name fga fgm f% 2a 2m 2% 3a 3m 3% totpt
andy
art
bart
bob
chris

Rather than being forced to a new page, start printing
again after chris with the player name and new field names:

Name dreb oreb totreb ast blksh
andy
art
bart
bob
chris
Click to expand...

You need two sets of detail records to do this kind of
thing. It can get a little messy, but here goes.

First, change the report's record source query to something
like this:

SELECT 1 As Batch, [Name], fga As Col2,
fgm As Col3, [f%] As Col4, [2a] As Col5,
[2m] As Col6, [2%] As Col7, [3a] As Col8,
[3m] As Col9, [3%] As Col10, totpt As Col11
FROM thetable
UNION ALL
SELECT 2, [Name], dreb,
oreb, totreb, ast,
blksh, Null, Null,
Null, Null, Null
FROM thetable


Now create a group with heading (and footer for team stats?)
on the Batch field. Place 10 labels in the group header
(after the Name label) for the column headings. Set the
names of thse labels to lblCol2 - lblCol11. Then use code
in the group header Format event to set the column heading
labels for the batch:

Select Case Me.Batch
Case 1
Me.lblCol2.Caption = "fga"
Me.lblCol3.Caption = "fgm"
. . .
Me.lblCol11.Caption = "totpt"
Case 2
Me.lblCol2.Caption = "dreb"
Me.lblCol3.Caption = "oreb"
. . .
Me.lblCol6.Caption = "blksh"
Me.lblCol7.Caption = ""
Me.lblCol11.Caption = ""
End Select

In the detail section bind the text boxes to the field names
Col2, Col3, etc.
Click to expand...
Click to expand...
 
Back
Top