Re: Average or "Harmonic Mean" calculation
- From: "Rob Parker" <CUT_THIS robpparker at optusnet dot com dot au>
- Date: Fri, 18 Nov 2005 10:31:30 +1100
Have a look at the reply from David Lloyd to a post "Normal Distribution" in
this newsgroup (less than 24 hours ago); it gives details on how to set up
an Access function to use an Excel function.
HTH,
Rob
"Jeff Boyce" <nonsense@xxxxxxxxxxxx> wrote in message
news:%23KoSrr86FHA.3648@xxxxxxxxxxxxxxxxxxxxxxx
> Cydney
>
> If exporting your data to Excel and using its HARMEAN() function isn't a
> possibility, you might be able to:
>
> 1. set a reference (open a module, select Tools|References, select the
> Excel Object model)
> 2. create a function that returns all the numbers, loading up a list of
> values
> 3. run the HARMEAN() function against the list of values
>
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "Cydney" <Cydney@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:822DA6AD-DBDE-4036-8B22-F811B7BF304A@xxxxxxxxxxxxxxxx
> > Excel has a "Harmonic Mean" calculation that I need to use in an Access
> > query. Is that possible? Formula in Excel is: =HARMEAN(R2:R28) I would
> > like
> > to apply this formula to a column of numbers on my form.
> > --
> > THX cs
>
>
.
- References:
- Re: Average or "Harmonic Mean" calculation
- From: Jeff Boyce
- Re: Average or "Harmonic Mean" calculation
- Prev by Date: Re: Selecting records at random from main table
- Next by Date: Re: Cross Tab Query, limit to # of Row Headings ?
- Previous by thread: Re: Average or "Harmonic Mean" calculation
- Next by thread: Date Format problem in parameter query
- Index(es):
Relevant Pages
|
