>>>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