Sorting question in access 2000 database

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi all,

I have a Access 2000 database.

In this DB I have a table with names of people.
This table is NOT unique ! so many people have there names multiple times in
this table.

How do I sort this so that the top 25 of the most entry's for a person come
on top.

So if Pete has 20 entry's (20 times in the DB) and Phil has 40 entry's,
Phil is on top with Pete second.

THX in advance !!
Tony

Sorry for my Bad english !!
 
Hi all,

I have a Access 2000 database.

In this DB I have a table with names of people.
This table is NOT unique ! so many people have there names multiple times in
this table.

How do I sort this so that the top 25 of the most entry's for a person come
on top.

So if Pete has 20 entry's (20 times in the DB) and Phil has 40 entry's,
Phil is on top with Pete second.
Click to expand...

Create a query based on the table selecting the name field *TWICE*.
Click the Greek Sigma icon (it looks like a sideways M) to make it
into a Totals query.

On one of the Name fields, leave the default "Group By" on the Totals
line; change the other to Count. This will give you a query listing
each name once with the number of occurances of that name. Sort
descending by this count.

One concern - names are NOT unique. Do you have some assurance that
all 40 entries for Phil refer to the same person? Might you not have a
Phil Jones and a Phil Roberts?
 
Thx John

That did the trick :)
I used only their first names, to not confuse the newsgroup.
So no problem there.

Thanx again :)

Tony
 
I used only their first names, to not confuse the newsgroup.
So no problem there.
Click to expand...

Still a problem. I know three people named Fred Brown, right here in
little Parma.
 
Back
Top