Access 2000 - Help needed in creating a simple Sort, maybe a For..Next Loop

  • Thread starter Thread starter mcg
  • Start date Start date
M

mcg

I'm absolutely new to Access 2000 and need some help in showing me how
to solve the following problem.
Example. I have a table called PEOPLE containing two columns NAME and
AGE. It goes something like this.

FRED 60
PETE 80
JIM 60
MARTIN 4
BERT 35
LINDA 80
TONY 60
SAM 35

I would like to create a chart from this table sorting the AGE in
descending order BUT where the AGE is equal they would share the same
chart position. Also where they share the same position NAME should be
sorted in ascending order. The end result should look like this:

1 LINDA 80
1 PETE 80
3 FRED 60
3 JIM 60
3 TONY 60
6 BERT 35
6 SAM 35
8 MARTIN 4

Your help is appreciated
mc
 
Back
Top