Field value count

Is there a way to get the count of the values in a field (DAO) without using an SQL statement?
If there isn't then what is the SQL statement to use to get the count?

[JHausmann]

SQL:

select field, count(field) group by field