Creating Multiple Rank Values

[matzos]

This is perhaps the silliest and frustrating thing that I have had to deal with in my history with Access.

I am creating a report that compares one date range with the same date range of the previous year. Simple.

The catch is that I have to sort the final report by the decending dollars spent of the current year and rank BOTH years. So a client may rank 3rd in the most current year range but have ranked 7th in the previous year range. I know how to rank just one using the running total feature of a report, but I can't figure for the life of me how to get both statically attributed to one client.

Please give me some ideas. I figure I have to have these rankings static in a table or query so that I can then sort the report appropriately.

I appreciate anything you can do to help! Thanks!

Kevin

 

[MichaelRed]

A way would be to add two 'rank' fields to the. When the report is (to be) run, update these rank fields before opening the report.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[matzos]

I'm afraid I don't follow your suggestion? Update the rank fields how? By query? If so, how?

Thanks for the response!

 

[MichaelRed]

? Of Course? by query. Create the queries which Orders the table by their 'Rank' Include the "Numbering" of the rank field in an update (this has been discussed -severally- in these forumns and is simplistic, but does require a static counter and a method to reset it).

Run both.

Run the report.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over