>I need a screen that shows the # of records in certain files for the client to be able to bring up. Is there a way to get RECCOUNT to NOT include the DELETED records prior to a PACK?
>
>Thanks

Peter,
You can do a SQL SELECT statement to do this.

Either
SELECT COUNT(*) AS RecCnt INTO CURSOR Dummy
Dummy.RecCnt will have the count

or
SELECT somefield INTO CURSOR Dummy
and check the value of _TALLY

Both these assume DELETED ON. If you don't have it ON you will need to add a where clause to exclude deleted records