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
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