In a table, I have a field which may contain duplicate entries (dups only in
the field, not row dups).

I need a query that will return only one record of each entry in this field,
as well as in a separate field, a count of how many were in the orginial
table.

i.e. if the value 06A34965 appeared three times in table 1, I want the query
to return just one row wiht 06A34965 with a count of 3. It does not matter
which of the 3 rows the query returns.

Thanks