counting records with "letters"? 1

[ISTodd]

Is it possible to have access assign a letter (A, B, C) to records in a list over a group in the detail of a report?

ie.
Currently:
1 Asia
2 Africa
3 Europe

Hoping for:
A Asia
B Africa
C Europe

Thanks for any help....

 

[GingerR]

using CHR(), A = chr(65), B = chr(66) and so on.
If you'll be using this conversion in multiple places throughout your DB, you can write a function. But just to test it, in a query that is based on your table, you could put this (sub in your ID field name for CountryID):

Expr1: Chr(65+([CountryID]-1))

and it will convert; do you have fewer than 26 countries? If not, you'll have to write a function that doubles the letters to like "AA", "AB", etc. Hope this is enough to get you thinking.

g

 

[dhookom]

Is the 1,2,3 derived using a running sum? If so, create a new text box and set its control source to:
=Chr(64 + txtRunSum)

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[ISTodd]

Thanks Duane, that was actually painless - Todd