Are you referring to the statistical measure of central tendancy when you
say "MODE"?
Excel has a function for that, have you tried exporting your data set to
Excel and using that function?
If you MUST do this in Access, you could:
* use the Tools|Reference menu choice in a code module to set a reference
to the Excel function
* make sure you generate a set of data that matches what the Excel
function expects to work with
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.
