Count limits

  • Thread starter Thread starter swansonray
  • Start date Start date
S

swansonray

In my detail section I have a text box. The control source is =1 and Running
Sum = Over Group.

The report prints six records per page. The current result (of the text box)
is on page 1 I have records 1 - 6. On page 2 the report displays 7 - 9 and
then 01 repeating.

What I want the report to do is on page 1 - records 1 - 6.
On page 2 I want it to display 1 - 6 again etc...

Thank you in advance.

Sincerely, Ray
 
swansonray said:
In my detail section I have a text box. The control source is =1 and Running
Sum = Over Group.

The report prints six records per page. The current result (of the text box)
is on page 1 I have records 1 - 6. On page 2 the report displays 7 - 9 and
then 01 repeating.

What I want the report to do is on page 1 - records 1 - 6.
On page 2 I want it to display 1 - 6 again etc...
Click to expand...

First, change the RunningSum to Over All and move the text
box to an out of the way position.

Let's say the running sum text box is named txtRunCount.
Add another text box with the expression;
=txtRunCount - 6 * (Me.Page - 1)

Once you get it all working, you can make the the running
sum text box invisible.
 
swansonray said:
In my detail section I have a text box. The control source is =1 and Running
Sum = Over Group.

The report prints six records per page. The current result (of the text box)
is on page 1 I have records 1 - 6. On page 2 the report displays 7 - 9 and
then 01 repeating.

What I want the report to do is on page 1 - records 1 - 6.
On page 2 I want it to display 1 - 6 again etc...
Click to expand...

First, change the RunningSum to Over All and move the text
box to an out of the way position.

Let's say the running sum text box is named txtRunCount.
Add another text box with the expression;
=txtRunCount - 6 * (Me.Page - 1)

Once you get it all working, you can make the the running
sum text box invisible.
 
I followed instructions and the end result displays "#name?" in the new text
box. This is what is in the control source for the new text box:
=[txtRunCount]-6*([Me].[Page]-1)
Also when I run the report it gives me a box asking me to enter a parameter
value for "Me"

Ray
 
I followed instructions and the end result displays "#name?" in the new text
box. This is what is in the control source for the new text box:
=[txtRunCount]-6*([Me].[Page]-1)
Also when I run the report it gives me a box asking me to enter a parameter
value for "Me"

Ray
 
Sorry, I was thinking VBA code when I wrote that control
source expression. It should have been:
=txtRunCount - 6 * (Page - 1)
Did you rename the running sum text box to txtRunCount? If
not, you need to either do that or use your name in the
above expression.
--
Marsh
MVP [MS Access]

I followed instructions and the end result displays "#name?" in the new text
box. This is what is in the control source for the new text box:
=[txtRunCount]-6*([Me].[Page]-1)
Also when I run the report it gives me a box asking me to enter a parameter
value for "Me"

Marshall Barton said:
First, change the RunningSum to Over All and move the text
box to an out of the way position.

Let's say the running sum text box is named txtRunCount.
Add another text box with the expression;
=txtRunCount - 6 * (Me.Page - 1)

Once you get it all working, you can make the the running
sum text box invisible.
Click to expand...
Click to expand...
 
Sorry, I was thinking VBA code when I wrote that control
source expression. It should have been:
=txtRunCount - 6 * (Page - 1)
Did you rename the running sum text box to txtRunCount? If
not, you need to either do that or use your name in the
above expression.
--
Marsh
MVP [MS Access]

I followed instructions and the end result displays "#name?" in the new text
box. This is what is in the control source for the new text box:
=[txtRunCount]-6*([Me].[Page]-1)
Also when I run the report it gives me a box asking me to enter a parameter
value for "Me"

Marshall Barton said:
First, change the RunningSum to Over All and move the text
box to an out of the way position.

Let's say the running sum text box is named txtRunCount.
Add another text box with the expression;
=txtRunCount - 6 * (Me.Page - 1)

Once you get it all working, you can make the the running
sum text box invisible.
Click to expand...
Click to expand...
 
Thank you. That did the trick!

Marshall Barton said:
Sorry, I was thinking VBA code when I wrote that control
source expression. It should have been:
=txtRunCount - 6 * (Page - 1)
Did you rename the running sum text box to txtRunCount? If
not, you need to either do that or use your name in the
above expression.
--
Marsh
MVP [MS Access]

I followed instructions and the end result displays "#name?" in the new text
box. This is what is in the control source for the new text box:
=[txtRunCount]-6*([Me].[Page]-1)
Also when I run the report it gives me a box asking me to enter a parameter
value for "Me"

Marshall Barton said:
swansonray wrote:

In my detail section I have a text box. The control source is =1 and Running
Sum = Over Group.

The report prints six records per page. The current result (of the text box)
is on page 1 I have records 1 - 6. On page 2 the report displays 7 - 9 and
then 01 repeating.

What I want the report to do is on page 1 - records 1 - 6.
On page 2 I want it to display 1 - 6 again etc...


First, change the RunningSum to Over All and move the text
box to an out of the way position.

Let's say the running sum text box is named txtRunCount.
Add another text box with the expression;
=txtRunCount - 6 * (Me.Page - 1)

Once you get it all working, you can make the the running
sum text box invisible.
Click to expand...
Click to expand...
Click to expand...
 
Thank you. That did the trick!

Marshall Barton said:
Sorry, I was thinking VBA code when I wrote that control
source expression. It should have been:
=txtRunCount - 6 * (Page - 1)
Did you rename the running sum text box to txtRunCount? If
not, you need to either do that or use your name in the
above expression.
--
Marsh
MVP [MS Access]

I followed instructions and the end result displays "#name?" in the new text
box. This is what is in the control source for the new text box:
=[txtRunCount]-6*([Me].[Page]-1)
Also when I run the report it gives me a box asking me to enter a parameter
value for "Me"

Marshall Barton said:
swansonray wrote:

In my detail section I have a text box. The control source is =1 and Running
Sum = Over Group.

The report prints six records per page. The current result (of the text box)
is on page 1 I have records 1 - 6. On page 2 the report displays 7 - 9 and
then 01 repeating.

What I want the report to do is on page 1 - records 1 - 6.
On page 2 I want it to display 1 - 6 again etc...


First, change the RunningSum to Over All and move the text
box to an out of the way position.

Let's say the running sum text box is named txtRunCount.
Add another text box with the expression;
=txtRunCount - 6 * (Me.Page - 1)

Once you get it all working, you can make the the running
sum text box invisible.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top