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