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