Create a calculation field with this calculation:
Right ( "00000000" & __kp_AdjustmentID ; 8 )
Perfect, thank you so much!
Have a look at the SerialIncrement() function.
Hi Michael, flusheddata's tip seems to be what I'm looking for, since I already have the existing serial number, I just need to make it exactly 8 digits. The SerialIncrement function doesn't exactly fit my purpose, but I think I might be able to use it for some of my other tables. I appreciate the help!
1 of 1 people found this helpful
The SerialIncrement function doesn't exactly fit my purpose,
I believe that =
SerialIncrement ( "00000000" ; __kp_AdjustmentID )
will do exactly what you asked for.
Hey that's right! It was my first time to encounter SerialIncrement so I just looked up the usage and from the examples given, I thought it just dealt with serial numbers where you had to indicate the number to increment it by. Shows how little I know. Thanks Michael, this is also a great tip!