Ranking Groups of Data (1 Viewer)

[jwaters]

What would be the easiest approach for creating a field that ranks data for a report?

Example, I have a field that ranks individuals based on specific date and other criteria's.

I want to have access calculate the rank value for each individual based on the different criteria's. One wrinkle is that the ranking has several classes and I need access to recognize the different classes and
start over ranking from 1 when finished analyzing each individual class and starting a new one.

Example: You have 100 people broken into 4 categories.

Each category needs to be numerically ranked based on the date the individual was promoted and by a specific ranking number based on their promotion placement in case there were duplicates that were promoted
on the same date. Classes are separated by a specific field identifier.

For this example the four classes are by the letters A, B, C and D.

Any help with my delima would be deeply appreciated.

Thanks,

JWaters

 

[Pat Hartman]

You can do this in the report as long as the report groupings are set correctly. Define a Ranking field in the detail section. Set it's record source to:
=1
Then set the field's running sum property to Over Group.