auto generated number issue - should be an easy one!

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

Here is my formula:

Right("000000" & ToText (118782-[Record ID#]),6)


my current record is 114789 so the auto generated number shows 003993

My next record would be 114790 so the auto generated number would show 003992

I want my numbers to go up instead of down. I am having a blank moment here and can figure out the math equation to make it go up instead of down. Any help on this would be appreciated.

003993, 003994, 003995, etc

Photo of mkosek

mkosek

  • 928 Points 500 badge 2x thumb

Posted 5 years ago

  • 0
  • 1
try this

Right("000000" & ToText ([Record ID#]-118782+3993),6) // ie zero out the counter but then restart at 3993