Good idea. Thanks
>>I have a large table that I need to count the number of records on a regular basis. I was using - Count to nRecords - but it got to be too slow. So I created an index on Deleted() and am now using the following code. It is now instant.
>>
>>Does anyone see a problem with this? TIA
>>
>>Set Deleted Off
>>Select TableName
>>Count To nDel For Deleted()
>>Goto Bottom
>>nCnt=RecNo()-nDel
>>Set Deleted On
>
>There will be an incorrect nCnt if there is an ORDER set on the table (GOTO BOTTOM may not put you on the last RECNO()). You can replace the
>
>GOTO BOTTOM
>nCnt = RECNO() - nDel
>
>with
>
>nCnt = RECCOUNT() - nDel
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108