Unfortunately, Access does not have a MODE function. You can find the mode
in a query, but you didn't say how you wanted to use it. Here's a really
good reference about using statistics in SQL: http://oreilly.com/catalog/transqlcook/chapter/ch08.html. Most of it
applies to Access. About halfway down the page shows how to calculate a
Mode in SQL.
I showed how to do it in Access in my October, 2005 "Access Answers" column
in Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
I showed how to do it in Access in my October, 2005 "Access Answers"
column in Pinnacle Publication's "Smart Access". You can download the
column (and sample database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
Unfortunately, Access does not have a MODE function. You can find the
mode in a query, but you didn't say how you wanted to use it. Here's a
really good reference about using statistics in SQL: http://oreilly.com/catalog/transqlcook/chapter/ch08.html. Most of it
applies to Access. About halfway down the page shows how to calculate a
Mode in SQL.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
