>If SET DELETED is ON you don't even need the FOR !DELETED() part. COUNT respects the status of SET DELETED where RECCOUNT() does not.
>
Dean, also bear in mind that the COUNT command sets your pointer to EOF().
>>How about COUNT FOR !DELETED() TO liCount?
>>
>>
>>>Does any one know what the best way is to finding the total number of records in a table without adding in the records marked for deletion?
>>>I have set deleted on.
>>>The way I am currently doing it is by doing a select statment on the table and then doing a _tally command. It works but it seems like there should be a easier way.
>>>
>>>example: Select * from Table1 into cursor Test
>>> lnTally = _tally
>>>
>>>Thanks,
Kenneth.