Assigning ranks to values

J

Jon

Hi,

I'm sorta new to Access and I can't find anything to
answer this question.

I have a list of batters' (MLB) statistics in a table. I
have a series of queries sifting the players by team and
totaling the teams' players' stats. I want to rank the
team totals and end up with a number for the ranking
(i.e. 1 for 1st, 2 for 2nd...etc.). Also, I need to have
a ranking for each individual stat. I can do this in
Excel, but I can't find anything on it in Access. This
is in Access 2000, BTW. Any help is greatly
appreciated. :)
 
T

Tom Ellison

Dear Jon:

Please write the query you want except for the ranking column. This
query should be ordered so the top rank is the first row. Post the
SQL of it here and I'll try to add the ranking column to it.

I suggest the results will be ranked like a horse race. A photo
finish for first place between 2 horses results in 2 first place
rankings and no second place. Is this OK?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
J

Jon

Thanks for the reply. But now I must admit I'm a bit
confused, once again. How do I write a query so that all
of the totals from the queries that I used to filter by
team are included as rows, instead of a bunch of
columns? I have the feeling this is really easy, but I'm
just not seeing it. Thanks again. :)
 
T

Tom Ellison

Dear Jon:

I thought your original post was a question how to add the ranking
column, so I didn't know you didn't already have the rest of the query
you wanted.

I'm not sure then what you have for data and what you want the result
to look like. Could you please show table names and column names
along with sample data, then show what results you expect from that
and how the results will look.

Without some information like this it's hard to guess your situation.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
J

Jon

Sorry about the confusion. I thought I could do the
easier parts myself, but I guess not. Anyway, I have 12
different queries that add up totals from the original
table. Those numbers are are what I want, but I want to
get all 12 teams' totals into another table, like the
player records from the original table, but for the 12
teams. This new table of team records is where I
envisioned the ranking part coming in. Is there an
easier way to do this?
 
J

Jon

Bump.
-----Original Message-----
Sorry about the confusion. I thought I could do the
easier parts myself, but I guess not. Anyway, I have 12
different queries that add up totals from the original
table. Those numbers are are what I want, but I want to
get all 12 teams' totals into another table, like the
player records from the original table, but for the 12
teams. This new table of team records is where I
envisioned the ranking part coming in. Is there an
easier way to do this?

.
Click to expand...
 
Top