1
12ofuskids
how do I put line numbers on a page when the number of lines vary? can I use
a sum text box with conditional formating??
a sum text box with conditional formating??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
how do I put line numbers on a page when the number of lines vary
R
Rick B
Do a search. This is asked and answered alllll the time.
look for "consecutive number"
Rick B
look for "consecutive number"
Rick B
1
12ofuskids
Rick B said:Do a search. This is asked and answered alllll the time.
look for "consecutive number"
Rick B
I have searched consecutive numbers until I am blue in the face but I cannot find what I need. If anyone knows please be specific, my brain isn't working very well right now. Thanks
J
John Spencer (MVP)
More information may be needed. Do you want the line numbers to start over on
each new page or is the number consecutive throughout the report. Also, do you
want to number just the detail lines or every line including title lines,
summary lines, etc.
Simplest - number every detail line only.
Add a new control to the detail section
Set its properties as follows:
Control Source: =1
Running Sum: Overall
Try that and see if it gives you the results you want. IF not, then post back
with a little more detail on what you do want.
each new page or is the number consecutive throughout the report. Also, do you
want to number just the detail lines or every line including title lines,
summary lines, etc.
Simplest - number every detail line only.
Add a new control to the detail section
Set its properties as follows:
Control Source: =1
Running Sum: Overall
Try that and see if it gives you the results you want. IF not, then post back
with a little more detail on what you do want.