I am compiling a survye of the best restaurants in the city, I have a self relational field that tells me how many times each rest. is entered in each category.. how many votes "corky's" has for "best ribs" buckely's for best steak etc...

So after i import all off the ballots I get the results then export the reults fields - but I end up with something like this:

06 Cafe 1912

06 Cafe 1912

06 Cafe 1912

06 Cafe 1912

06 Cafe 1912

06 cafe 1912

05 Hueys

05 Hueys

05 Hueys

05 hueys

05 Hueys

How can i export JUST one result for each name.

there are 241 records, with 47 categories.

In the end I would like to have a list of results for each category like this:

28 Paulettes

10 La Tourelle

06 Cafe 1912

05 Hueys

04 Jarrets

THANKS!

If not sorted already, sort by the field.

Than run a loop script to omit all duplicate entries to the field. Once you have the final found set with records showing only one copy of the field value; export contents.

Do a search on removing duplicate entries. There should be a lot of posts on it.

Off hand, it should be a loop script that sets a global field to the current value. Then goes to next record. If the next record field value = the global field value then omit, else next record. etc.