Hi
I think this query this will do what you want
Code:
SELECT TOP 1 Table1.Data
FROM Table1
GROUP BY Table1.Data
ORDER BY Count(Table1.Data) DESC;
I Think (have go to go), but this will return the item that occurres most in the 'Data' field in Table1 !
Hope that is wat you hat in find ?
MTB