most often value in a field

[bbwolff]

How can i get the value that is used most common in one column of the table through vba code?

 

[Isskint]

You would need a DMean() function - something Access does not have.

Have a look at this link http://perrin.socsci.unc.edu/tips/src/daverages.txt. it lists a DMedian() and a DMode() function

EDIT
Just a thought, would a TOP 1 query do this??

SELECT TOP 1 Table1.Data
FROM Table1
GROUP BY Table1.Data
ORDER BY Count(Table1.Data) DESC;

 

[bbwolff]

this seems to work

Dim rs As DAO.Recordset
Dim strSQL As String

strSQL = "SELECT tName  FROM Table GROUP BY tName ORDER BY Count(table.tName) DESC;"

Set rs = CurrentDb.OpenRecordset(strSQL)

rs.MoveFirst

MsgBox rs!tName