Row numbers in report.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
Need help on this:

I have a report with typical 32-50 rows (sensors with serial num.).
When testing this sensors it is done in groups of 6 (sensors are marked 1=>6).

Therefor i need to a visable count from 1 to 6 and starting over 1 to 6 etc.
troughout all rows in detail field of report.
The serial numbers are unique and changes from test to test.

I have tried different grouping solutions but this is not possible (as far
as i know).

Michael...
 
Add a text box with properties:
Name txtCount
Control Source =1
Running Sum Over Group
Format General Number
Visible No
This text box gives you a count from one onwards.

Now you can use the Mod operator to get the remainder when divided by 6
(will be 0 to 5), and add 1 so you get 1 to 6.

Then add another text box with Control Source of:
=(([txtCount] - 1) Mod 6) + 1
 
Thanks Allen.
That was just what i was seeking - absolutley PERFECT!

Is it possible for me to pursuade You to use a couple of minutes to tell me
something about line properties?

All rows, in the report, are seperated by a line - is it possible to enhanse
the thikness of the line everytime the counter, you built for me, reaches 6?
( So the line between no.6 and the following no.1 is thiker)
This will give a clear grouping of the data on the report.

Annyway i want to say thanks for the help so far!

Michael...


"Allen Browne" skrev:
Add a text box with properties:
Name txtCount
Control Source =1
Running Sum Over Group
Format General Number
Visible No
This text box gives you a count from one onwards.

Now you can use the Mod operator to get the remainder when divided by 6
(will be 0 to 5), and add 1 so you get 1 to 6.

Then add another text box with Control Source of:
=(([txtCount] - 1) Mod 6) + 1

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

MID-DK said:
Hi all,
Need help on this:

I have a report with typical 32-50 rows (sensors with serial num.).
When testing this sensors it is done in groups of 6 (sensors are marked
1=>6).

Therefor i need to a visable count from 1 to 6 and starting over 1 to 6
etc.
troughout all rows in detail field of report.
The serial numbers are unique and changes from test to test.

I have tried different grouping solutions but this is not possible (as far
as i know).

Michael...
Click to expand...
Click to expand...
 
You could set the On Format property of the (Detail?) section to:
[Event Procedure]

Then click the Build button (...) beside this.
Access opens the code window.

Insert this line between the other 2:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Line1.BorderWidth = Me.[Text1]
End Sub

Replace Text1 with the name of your 2nd text box.

It just so happens that the BorderWidth property goes from 0 to 6, so it
suits your case. If you needed a higher number, you would need to use a
solid rectngle instead of a line, and set its Height in twips, where 1440
twips = 1 inch.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

MID-DK said:
Thanks Allen.
That was just what i was seeking - absolutley PERFECT!

Is it possible for me to pursuade You to use a couple of minutes to tell
me
something about line properties?

All rows, in the report, are seperated by a line - is it possible to
enhanse
the thikness of the line everytime the counter, you built for me, reaches
6?
( So the line between no.6 and the following no.1 is thiker)
This will give a clear grouping of the data on the report.

Annyway i want to say thanks for the help so far!

Michael...


"Allen Browne" skrev:
Add a text box with properties:
Name txtCount
Control Source =1
Running Sum Over Group
Format General Number
Visible No
This text box gives you a count from one onwards.

Now you can use the Mod operator to get the remainder when divided by 6
(will be 0 to 5), and add 1 so you get 1 to 6.

Then add another text box with Control Source of:
=(([txtCount] - 1) Mod 6) + 1

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

MID-DK said:
Hi all,
Need help on this:

I have a report with typical 32-50 rows (sensors with serial num.).
When testing this sensors it is done in groups of 6 (sensors are marked
1=>6).

Therefor i need to a visable count from 1 to 6 and starting over 1 to 6
etc.
troughout all rows in detail field of report.
The serial numbers are unique and changes from test to test.

I have tried different grouping solutions but this is not possible (as
far
as i know).

Michael...
Click to expand...
Click to expand...
Click to expand...
 
:)) Perfect Allen!

As a Newbee in the "access-World" it is nice to have this option to ask You
smart people out there (or in this case Down un-there ;).

Again..: Thank You for the help!
Michael...


"Allen Browne" skrev:
You could set the On Format property of the (Detail?) section to:
[Event Procedure]

Then click the Build button (...) beside this.
Access opens the code window.

Insert this line between the other 2:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Line1.BorderWidth = Me.[Text1]
End Sub

Replace Text1 with the name of your 2nd text box.

It just so happens that the BorderWidth property goes from 0 to 6, so it
suits your case. If you needed a higher number, you would need to use a
solid rectngle instead of a line, and set its Height in twips, where 1440
twips = 1 inch.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

MID-DK said:
Thanks Allen.
That was just what i was seeking - absolutley PERFECT!

Is it possible for me to pursuade You to use a couple of minutes to tell
me
something about line properties?

All rows, in the report, are seperated by a line - is it possible to
enhanse
the thikness of the line everytime the counter, you built for me, reaches
6?
( So the line between no.6 and the following no.1 is thiker)
This will give a clear grouping of the data on the report.

Annyway i want to say thanks for the help so far!

Michael...


"Allen Browne" skrev:
Add a text box with properties:
Name txtCount
Control Source =1
Running Sum Over Group
Format General Number
Visible No
This text box gives you a count from one onwards.

Now you can use the Mod operator to get the remainder when divided by 6
(will be 0 to 5), and add 1 so you get 1 to 6.

Then add another text box with Control Source of:
=(([txtCount] - 1) Mod 6) + 1

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi all,
Need help on this:

I have a report with typical 32-50 rows (sensors with serial num.).
When testing this sensors it is done in groups of 6 (sensors are marked
1=>6).

Therefor i need to a visable count from 1 to 6 and starting over 1 to 6
etc.
troughout all rows in detail field of report.
The serial numbers are unique and changes from test to test.

I have tried different grouping solutions but this is not possible (as
far
as i know).

Michael...
Click to expand...
Click to expand...
Click to expand...
 
Back
Top