>Thank you - I'm retired so, this is a recreation project with no deadline. I have separated a dictionary table into a word count, and nine word types. (Noun, pronoun etc)
>I have an application that counts words and, based on each words count (descending), need to put each word in its type column with the most used word, for each type at the top.
If you have a separate column for each of the nine word types, that strikes me as a bad design, which will cause you trouble sooner or later. It seems better to have a single column for "word type", and to put a code in this column, stating whether the specific word is a verb, a noun, etc. For words that can be in more than one word type, you may want to consider having several rows (records) for that word - either in the same table, or in a child table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
