Findes der en 'Mode' funktion i Access

En foresp kan returnere noget der ligner:

SELECT top 1 Count(felt) AS AntalFelt, felt
FROM Tabel3
GROUP BY felt
ORDER BY Count(felt) DESC;

Niels

Det kan man selvfølgelig gøre !

Jeg prøver lige at tage det op med ham i aften.

Ellers kan man lave sin egen:

Function maxAntal(tbl, felt As String) As String

    Dim rs As DAO.Recordset
    Dim strSql As String
    strSql = "SELECT top 1 " & felt & _
        " FROM " & tbl & " GROUP BY " & felt & _
        " ORDER BY Count(" & felt & ") DESC;"

    Set rs = CurrentDb.OpenRecordset(strSql)

    maxAntal = rs(0)
   
    rs.Close
    Set rs = Nothing

End Function