Re: [GENERAL] Ranking Results

2005-09-14 Thread Thomas O'Connell
On Sep 13, 2005, at 3:07 PM, Craig wrote: Hi   I have a query that is grouping by 3 fields and returning a sum of another field. I would also like a further field to be returned that shows a ranking for the records based on the sum field. This should really only be a numbering of the rows returned

[GENERAL] Ranking Results

2005-09-13 Thread Craig
Hi   I have a query that is grouping by 3 fields and returning a sum of another field. I would also like a further field to be returned that shows a ranking for the records based on the sum field. This should really only be a numbering of the rows returned, since I will do the ordering in an