Assigning numbers to records
Can someone tell me what a script would look like that would assign the following numbers to records? The first 20 records would be assigned numbers 1 through 20. Then, after 20, the numbers would be 1B, 10B, 2B, 11B, 3B, 12B, 4B, 13B, etc. The numbers would never go past 20.