Showing counts of records in file with same data

[efen]

Please help -- I am sure this will be amazingly simple for some of you out there but I can't get my head around how to do this.

I have a file (basic version attached) which parses a block of text into the individual words it contains (each word is made a separate record). These records/words are then sorted and a count of the occurrences of each word is shown by a subsummary.

What do I need to do to show the words sorted in ascending/descending order of the number of occurrences [can't sort by summary field?] rather than by word order?

Thanks in advance

efen

FileMaker Version: 6

Platform: Windows 95/98

Parse.zip

[-Queue-]

Select 'Include summary fields' in the sort dialog. Then you can sort by Count (asc/desc) first and Word second.

Also, put a Freeze Window step at the beginning of your parse script. It will speed up the process and make for a nicer interface.