Solved Serial number in Alphabets in MS Reports

[daud]

I want to assign serial number to each record via property>data>=1 overall. Its OK and serial 1, 2, 3 etc. However, I want to serial number alphabeticlly i.e a b c d and so on. I did this once in past using CHR(97), ASCII 97 represents a 98 represents b and so on. Unfortunately I could not do it now. If someone can help.
Regards and best wishes

 

[jdraw]

Perhaps an example would clarify your intent.

 

[CJ_London]

use one of the common methods to add numbers, then add 97 or 96 depending on whether the numbers start from 0 or 1

not clear from your post whether you are trying to do this in a query to update a table or using a rownumber in a report.

If a report, see this link for generating a rownumber

How to Number Report Records in Microsoft Access

Learn how to efficiently number and organize your report records in Access with this step-by-step guide.

www.techrepublic.com