Friday, 27 March 2009

Excel MODE function in Access

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.

Sunday, 15 February 2009

Under construction