>>>>>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.
>
>bottom line, your query will work regardless of 'Set Deleted'
Only if you don't use an alias in deleted() and only if your query accesses a single table.