>>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?
I ain't skeert of nuttin eh?
Yikes! What was that?