Creating a line item on Report

D

duckie1126

I would like to create a formula on my report creates a line item # on the
left hand side.

For example... I have over 1400 employees... instead of using the auto-
numbered field (because I've added and deleted) it's not completely accurate
numerically... I would like to create a simple formula that counts the line
item and then adds 1 for the next line item. Typically, you would see this
look on an old journal ledger... it’s just easier to read across the page and
stay on the same line.

1 Mrs. Smith
2 Joe Black
3 etc
4 etc
5 etc
6 etc

Then, theoretically, when I do my count at the end... it should equal the
last line item #.
TOTAL EMPLOYEES: 6

So… my question is… can someone assist me with a formula - any ideas??? I am
truly drawing a blank...

Does this make sense?

Thanks so much!
Kim
 
M

Marshall Barton

duckie1126 said:
I would like to create a formula on my report creates a line item # on the
left hand side.

For example... I have over 1400 employees... instead of using the auto-
numbered field (because I've added and deleted) it's not completely accurate
numerically... I would like to create a simple formula that counts the line
item and then adds 1 for the next line item. Typically, you would see this
look on an old journal ledger... it’s just easier to read across the page and
stay on the same line.

1 Mrs. Smith
2 Joe Black
3 etc
4 etc
5 etc
6 etc

Then, theoretically, when I do my count at the end... it should equal the
last line item #.
TOTAL EMPLOYEES: 6

So… my question is… can someone assist me with a formula - any ideas??? I am
truly drawing a blank...


If the numbers are not related to the records in the report,
then just use a text box with the expression =1 and
RunningSum set to Over All
 
D

duckie1126

That was too easy! Thanks so much. I knew it had to be simple! UGHhhhh! I
was over thinking it!
Thanks again!

Marshall said:
I would like to create a formula on my report creates a line item # on the
left hand side.
[quoted text clipped - 19 lines]
SoÂ… my question isÂ… can someone assist me with a formula - any ideas??? I am
truly drawing a blank...

If the numbers are not related to the records in the report,
then just use a text box with the expression =1 and
RunningSum set to Over All
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top