AnsweredAssumed Answered

Record Counting

Question asked by Jason_Farnsworth on Dec 7, 2011
Latest reply on Dec 7, 2011 by RayCologon

Looking for some advise on how for get Records to number themselves via this format


N0500,N0501,N0502.....N1500,N1501....Etc I do not use this as RecordID it is a field within the table.


I need the first Record to start a N0500 and get progressively bigger. The thing that is getting me is starting with N0500 and counting up from there and when it hits N1000 to roll off the zero.


Thanks in Advance,