insert text in selected record

[King_George]

I want disply my query result(result1, result2, result3) like this:

A. result1
B. result2
C. result3

How can I insert the A, B, and C in it? Thanks.

I can think of at least one way, but just to be sure, how is the report obtaining data? Directly from the database, ttx file or ...?

[Palmtree]

Thanks for the reply. I get data from database.

[King_George]

Thanks for the reply. I get data from database.

Here's a quick and dirty way that works fine as long as there isn't more than 26 records. If there is, then you have to change the formula to handle it.

1. Create a formula field on the report.
2. In the formula field put this formula:
chr(64 + RecordNumber) & "."
3. Place the formula field on the left of the record in the detail line.
4. run the report.

Remember that will only work from A to Z. After that then you get a to z and 0 to 9 and then whatever ascii character corresponds with the formula.

HTH

[Palmtree]

Thanks so much. I will give it a try.