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