Need help on Ranking report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SG - 28 Sep 2005 18:07 GMT

Hi,

I'm using Access 2002, and I'm assigned a task to develop a report which is
going to rank customer sales by city.
I don't know if this is possible to do:
rank / acct# / name / city / sales
1 1001 abc Toronto 100.00
2 1003 dcc Toronto 60.00
3 1004 ddf Toronto 30.00
page break and total for city "Toronto", then starts another city below on
the same report:

1 3004 bef Markham 2300.00
2 3005 fjd Markham 2100.00
.....
page break and total for city "Markham".

I was able to do only one ranking on one report, how do I do to ranking by
each city?

I will greatly appreciate it.

Thanks,
Sarah

Reply to this Message

jl5000 - 30 Sep 2005 01:55 GMT

In the sort grouping section of your report, you can create one group for the
city, then a second group/sort by amount and sort the amount in descending
order,

If you are currently grouping the report to calculate totals from the raw
data, change your query to do that calculation, by grouping the records by
city, acct#, name, and sum of the amount, so the sort I'm describing works

To put the ranking use a running total with a variable on the report that
resets every group change

Signature

jl5000
<a href="http://www.joshdev.com"></a>

> Hi,
>
[quoted text clipped - 20 lines]
> Thanks,
> Sarah

Reply to this Message