Continuous alpha labels in reports

Y

yvette

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...?
 
K

KARL DEWEY

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

Chr(Asc([MyData])+1)
 
Y

yvette

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

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

Chr(Asc([MyData])+1)

yvette said:
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...?
Click to expand...
Click to expand...
 
K

KARL DEWEY

[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)

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

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

Chr(Asc([MyData])+1)

yvette said:
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...?
Click to expand...
Click to expand...
Click to expand...
 
Y

yvette

It works! THANK YOU.

KARL DEWEY said:
[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)

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

KARL DEWEY said:
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...?
Click to expand...
Click to expand...
Click to expand...
 
Top