>Reccount() gives a total of all records in a table whether deleted, or not. What is the most efficient way to determine the number of 'not' deleted records?
>
>Many thanks!

You have to count them.

Select count(*) from yourtable where !deleted() into array laDummy
?laDummy

Note that you must have Set Deleted On for this to work.