Page 1 of 1
Numbering found records
Posted: Wed Jul 25, 2001 12:53 pm
by 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.
=> RE: Numbering found records
Posted: Wed Jul 25, 2001 1:52 pm
by 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
==> RE: Numbering found records
Posted: Thu Jul 26, 2001 8:26 am
by 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.