The only way I can think of at the moment is to create a "Totals" query that returns just the data from the first column:
Code:
SELECT Table1.Field1FROM Table1
GROUP BY Table1.Field1;
In the attached example db I have called this "qryGroupBy".
Create a function in a general module. I have called mine "fnGetNames".
Create a query based on the query "qryGroupBy" that uses "fnGetNames" to return the names. I have called this query "qryGetNames".
Using a user defined function in a query can be slow when the number of records is large but until some one comes by with something quicker, this does at least produce the right result. Hope this helps.