How to count down on left margin?

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

Guest

I am wanting to count down on the left margin of my report. Like this:

1
2
3
4
5
6

I don't want these numbers to be tied to any record in the detail, just part
of the report format.

Any help would be greatly appreciated!
 
Amanda said:
I am wanting to count down on the left margin of my report. Like this:

1
2
3
4
5
6

I don't want these numbers to be tied to any record in the detail, just part
of the report format.
Click to expand...


You can run a counter of the details in the report (not
necessarily the lines) by using a text box with the
expression =1 and setting its RunningSum property to Over
All.

If you want the numbers to start fresh on each page and/or
want the numbers on each line regardless of the detail
boundaries, then it gets trickier.
 
Hi, Amanda.
I am wanting to count down on the left margin of my report.
Click to expand...

Open the report in Design View. Create a new text box and place it in the
left margin of the Detail section. Open the Properties dialog window and
select the Data tab. Select the "Running Sum" Property and change it to
"Over All." Select the "Control Source" Property and change it to "=1"
(without any quotation marks). Save the report, close the Properties dialog
window, and open the report in Report View. You will see the count along the
left margin for each record.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top