Count limits

[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

 

[Marshall Barton]

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.

 

[Marshall Barton]

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.

 

[swansonray]

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

 

[swansonray]

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

 

[Marshall Barton]

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"

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.

 

[Marshall Barton]

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"

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]

Thank you. That did the trick!

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"

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.

 

[swansonray]

Thank you. That did the trick!

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"

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.