>>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
--sb--