Perry,

You can get what you want with one SELECT.

SELECT s_or_status, COUNT(*) FROM TableName GROUP BY s_or_status INTO CURSOR Result

Result will have one record for each Status value with the count of records that had that value.