>Hi all,
>
>I'm wondering how far set filter to in VFP can do the most like in Excel :
>
>Because in Excel we can set filter to any fields in the sheet, can we do the same thing with VFP ?.
>
>Please give the advices , really appreciated in advance.
>TIA
You can put the filter to any condition on a table. The condition can involve one field, or even not name any field at all, such as a filter that involves deleted() or recno().
For example (in a DBF that contains a list of people):
set filter to LastName = "P"
set filter to Age <= 40
set filter to LastName = "P" and age <= 40
set filter to recno() % 100 = 0
set filter to "x" $ LastName
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)