Ranking within Category

[Guest]

I am relatively new to Access. I have created a report that is grouped by
category name, and is sorted descending on the field "dollars" for each
category. I need to add a ranking to each record as it relates to the rest of
the category, not the entire report. I need to do this for the field
"dollars" and the field "units". Any help is greatly appreciated.

thanks

Jeff

 

[Guest]

Hi

ASdd an unbound textbox to you report - in the details section.
Open the properties box
Select the Data coloum
Select the Row Source row insert =1
In the same coloum select Running Sum - Select yes / over group


Hope this helps