>>>>>>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.
>
>Without seeing the table structures, it's hard to give specific advice (and I pretty much agree with Hilmar that multiple columns to represent the same kind of thing is bad design). However, a SQL query using COUNT() will give you the ordering you need; you can use that to do another query to put the actual data in order.
>
>Tamar

Thanks Tamar. I got the answer from Mike. I was making an indexing error.