Can median be calculated in Accesss? I need to make a report w/both average
& median statistics. Thanks!

"Leslie Mertle" <Leslie (E-Mail Removed)> wrote in message
news:9E0F229F-E0BB-461E-9735-(E-Mail Removed)...
> Can median be calculated in Accesss? I need to make a report w/both
> average
> & median statistics. Thanks!


See
http://support.microsoft.com/default...b;en-us;209244
or
http://support.microsoft.com/default...b;en-us;210581

--
Joan Wild
Microsoft Access MVP

I think the better method (because you know there will be more functions that
you need in access) is:
"How to call Excel functions from within Access 2000"
http://support.microsoft.com/default...b;en-us;198571

"Joan Wild" wrote:

> "Leslie Mertle" <Leslie (E-Mail Removed)> wrote in message
> news:9E0F229F-E0BB-461E-9735-(E-Mail Removed)...
> > Can median be calculated in Accesss? I need to make a report w/both
> > average
> > & median statistics. Thanks!
>
>
> See
> http://support.microsoft.com/default...b;en-us;209244
> or
> http://support.microsoft.com/default...b;en-us;210581
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>

You want to instantiate a full copy of Excel, just to use one of its
functions? Instead of running a few lines of code within the existing
instance of Access?

The Excel method would be about 20 squintillion times slower & more
resource intensive. Can't see why you'd say it was better!

TC