creating a top ten list

[TheGrinch]

Hello All,

I have a DB of around 10k records. One of the fields, "company", has 10k entries, with say 5k unique entries. For each record there is a count field that gives the total no. companies for the particular company in that record.

for example: record 1 has company "IBM", the count field gives 25 as there are a total of 25 IBMs in the DB.

I want to create twenty new fields:

Company#1, Company#2.....Company#10

CompanyCount#1, CompanyCount#2......CompanyCount#10

Is there anyway I can populate these fields with the top ten company names together with their counts.

Any suggestions/comments appreciated.

CHEERS

[BrentHedden]

How about sorting (descending) the relationship according the the count?

[TheGrinch]

That doesnt help me since i get a list where the top company appears 50 times with its count, then the second company is listed 20 times with its count...

[CoZiMan]

Create a value list from the SORTED records and select the top ten results to copy into a new field that isn't the value list

That should work.