calculate median in Access

  • Thread starter Thread starter khaymon
  • Start date Start date
K

khaymon

I'm using the article: http://support.microsoft.com/kb/210581 to calculate a
median in access. However, I'd like to calculate the median on subsets of
data by using a query. I can't seem to get the code to work with a query
rather than a table. How can I get the module and form to work with a query
rather than a table? or get the median function to work in a query itself?
 
Save the function in a standard module, labeled with a different name than
the function. Add the Keyword Public in front of function (just in case) In
the query, create a column like:

Expr1: Median("tblMyData","Whatever")

It should work just fine.
 
Back
Top