You can use this in a function:

COUNT FOR !DELETED() TO lnRecordCount

>Hi everyone,
>
>It just occured to me that when I use the reccount() function or an SQL count function it counts the deleted entries (the ones with their "squares" black) and I don't want those included in my totals.
>
>Do I have to write a separate function or is there an existing command (something like SET DELETES OFF) that I can use in order to count ONLY the entries that are not deleted?
>
>And if I have to write a function, what kind of conditions have to be included in it?
>
>Thanks a lot in advance, Steph.