Currently there is no Mode function in Access but you can use following SQL statement to return most frequently occurring value in certain field.
SELECT TOP 1 Test.Test FROM Test GROUP BY Test.Test ORDER BY Count(Test.Test) DESC;
To use this SQL statement,
Create table called 'Test' with atleast one field 'Test'.
Copy and paste above statement in query to get most occuring value in field.
Friday, 27 March 2009
Subscribe to:
Posts (Atom)