Calculating a Median

  • Thread starter Thread starter Mike Lempel
  • Start date Start date
M

Mike Lempel

Is there a Median function available in Access that works like other domain
aggregate functions (e.g. like DAvg («expr», «domain», «criteria») )? Has
anyone created one that I could use, or can anyone provide some ideas on how
to build one?

Thanks very much for any help.

Mike
 
No, there is no such built-in function.

Googling on:

"median function" vba

gives about 30 hits. Maybe there's something in there.

HTH,
TC
 
Hi Mike

I wrote a function that does that. If you would like a small sample database,
just send me an email.

Best regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Back
Top