>>>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.
>
>'Set Deleted On' is not required for your query.
>If you have 'Set Deleted On', you don't need !deleted() in the query

Right, I had a minor brain short circuit.