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

If there's an index on DELETED():

FUNCTION CountUndeleted
LPARAMETER cAlias
LOCAL cInAlias, cOrder, cDeleted, nRecPos, nDeleteCount, nResult
IF USED(cAlias)
   cInAlias = ALIAS()
   SELECT(cAlias)
   cOrder = cOrder
   cDeleted = SET('DELETED')
   nRecPos = RECNO()
   SET DELETED OFF
   SET ORDER TO 0
   COUNT FOR DELETED() TO nDeleteCount
   nResult = RECCOUNT() - nDeleteCount
   IF cDELETED = 'ON'
      SET DELETED ON
   ENDIF
   IF nRecPos # 0
      GO nRecPos
   ENDIF
   IF ! EMPTY(cOrder)
      SET ORDER TO &cOrder
   ENDIF
   IF ! EMPTY(cInAlias)
      SELECT (cInAlias)
   ELSE
      SELECT 0
   ENDIF
   RETURN nResult
ELSE
   RETURN NULL
ENDIF

>And if I have to write a function, what kind of conditions have to be included in it?
>
>Thanks a lot in advance, Steph.