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