>>actually Al i was trying to adapt the 'find duplicates' code that Hilmar sent me for a new task. the new task was to display names for those records with data in the field ex2s and then display those names as a text string - sorry for the confusion.
>>exs2 is a numeric field
>>vname is a character field which contains a name.
>>
>>k
>>
>Please post the input and desired output. In the meantime you may want to read the following blogs (even though they are for SQL Server, some of the techniques can be easily applied to VFP):
>
>Optimizing TOP N per Group Queries - blog by Itzik Ben-Gan explaining various optimization ideas
>
>Including an Aggregated Column's Related Values - Erik and mine blog presenting several solutions of the problem with explanations for each
>
>Including an Aggregated Column's Related Values - Part 2 - my blog post with use cases for the previous blog


thanks Naomi i was just wondering if there was simply another alternative to the 'list' function that would store the info into a variable - something like "List all name for ex2s>0 to N
I suppose -- set alte to n.txt -- List all name for ex2s>0 --- would do it. (with proper syntax of course)

k




k