Continuous alpha labels in reports

[Guest]

Is there a way to label report detail rows alphabetically? I know about the
running sum function to number report details 1,2,3,etc...but is there a
similar function for labeling rows A,B,C,etc...?

 

[Guest]

Can you not just increment the ascii and display?
Asc( to get the code and Chr( to display alpha characters.

Chr(Asc([MyData])+1)

 

[Guest]

Does this formula go into the Control Source field of a text box in the
report? What does the [MyData] refer to?

Can you not just increment the ascii and display?
Asc( to get the code and Chr( to display alpha characters.

Chr(Asc([MyData])+1)

Is there a way to label report detail rows alphabetically? I know about the
running sum function to number report details 1,2,3,etc...but is there a
similar function for labeling rows A,B,C,etc...?

 

[Guest]

[MyData] is the data source for the row number.

You mentioned you knew how to use "the running sum function to number report
details 1,2,3,etc..."

Use your running sum function with VISIBLE property set to No. Use that
field as data source for this text box.

The character "A" is ascii 65. So take the row count plus 64.

Something like Chr( [YourRunningSumTextBox]+ 64)

Does this formula go into the Control Source field of a text box in the
report? What does the [MyData] refer to?

Can you not just increment the ascii and display?
Asc( to get the code and Chr( to display alpha characters.

Chr(Asc([MyData])+1)

Is there a way to label report detail rows alphabetically? I know about the
running sum function to number report details 1,2,3,etc...but is there a
similar function for labeling rows A,B,C,etc...?

 

[Guest]

It works! THANK YOU.

[MyData] is the data source for the row number.

You mentioned you knew how to use "the running sum function to number report
details 1,2,3,etc..."

Use your running sum function with VISIBLE property set to No. Use that
field as data source for this text box.

The character "A" is ascii 65. So take the row count plus 64.

Something like Chr( [YourRunningSumTextBox]+ 64)

Does this formula go into the Control Source field of a text box in the
report? What does the [MyData] refer to?

Can you not just increment the ascii and display?
Asc( to get the code and Chr( to display alpha characters.

Chr(Asc([MyData])+1)

:

Is there a way to label report detail rows alphabetically? I know about the
running sum function to number report details 1,2,3,etc...but is there a
similar function for labeling rows A,B,C,etc...?