Michael,

This will do it with two selects:

SELECT field1 FROM anyTable INTO CURSOR intermediate GROUP BY field1
SELECT CNT(field1) FROM intermediate

HTH,
Bill