Numbering found records

[pmeadows_(Guest)]

How do you number the records found in a list. Starting with the first record found in a sort, then adding 1 to the count for the next record and so on. The end result is a list ranked from 1 to 225 in the left hand margin, example: Top 225 Customers.

[kfleming]

You can use a calculated field with the RECNO() function to return the R&R composite record number.__I think that this will give you the desired result.____Kathleen__R&R Support

[pmeadows_(Guest)]

I created a total field using a count on the Customer_Name, reset on Grand Total, Accumulation on the grouping Customer_Name, and using the Processing as Running. This gave me the result I needed to number the customers when ranked by sales. The RECNO() function was only giving me the actual record number in the table.