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
Sunday 15 February 2009
Subscribe to:
Posts (Atom)