A
AOMR
What is the Formula in Access to find the most repetitive number. In excel is
"Mode" but I can't seem to find it to work with Access.
"Mode" but I can't seem to find it to work with Access.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Carlson
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.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
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.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
D
Douglas J. Steele
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
in Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html
K
kate
Douglas J. Steele said: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
K
kate
Roger Carlson said: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.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L