Gnana,
VFP uses the same table again with a filter when it can to resovle a SELECT. When it does this RECCOUNT() is the same as the original table. You need to use _TALLY to find out how many records met your criteria. You can also use the NOFILTER clause in the SELECT statement to force the creation of a disk presence for the cursor, this way RECCOUNT() and _TALLY will be equal (but your queries may take longer to complete).