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,