>>>>Please help my elderly brain
>>>>
>>>>SET ORDER to field1 > 0 AND field2 = 3
>>>>
>>>>I need to accomplish this, but haven't been successful. Any help appreciated
>>>
>>>SET FILTER, mentioned in the other reply, is used to show only specific records. You can also SELECT FROM ... WHERE [condition].
>>>
>>>SET ORDER is used to activate a specific, already existing, index. These are used mainly for ordering.
>>
>>Thanks Hilmar - The table must be accessed but not seen so, SELECT FROM is not the answer. I am having some success SETting the ORDER and using SKIP to gather information from each field, but need to index on 9 fields. Maybe one index for each field is the answer. What do you think?
>
>Grady-what are you trying to do? If you need info from each field, SQL SELECT may well be the right answer. The results only show up in a browse if you fail to include the INTO clause.
>
>Tamar

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.