I've attempted to do some research on this but land up in the sections of the
book(s) that deal with programming (which I am not yet there) so I look for
your help at MS Discussion.

There are two fields that I would like to include on this one specific
report which call for the calculation of the Average and the Median
(statistical functions).

I have heard it said that all I have to do is call the Excel worksheet
function from Access ... 'you must have a reference set to excel or late bind
to excel as these worksheet functions are called from excel ...
'worksheetfunction.Excelfunctionname AnyParametersneeded'.

That's still unclear to me. I am such a newbie at creating modules etc.
that I need more tutoring on this in order to make it happen.

Can anyone help?


--
Thanks,
Steve D

Steve

The book tells you that use of references involves programming. You post in
a "programming"-related newsgroup. But you want a non-programming
explanation?! <g>

To use the Excel function, after you've set a reference to it in Access,
you'll need to 'ken' some programming. To set the reference, create a new
module, click Tools|References, and locate the line that has your version of
MS Excel. Check the box and Save/close. Your mdb now has a reference to
the Excel object model, including the Median function.

By the way, Access does have an "Average" function, as part of its Totals
query -- but it does expect to have normalized data to work on.

--
Good luck

Jeff Boyce
<Access MVP>

"Steve D" <(E-Mail Removed)> wrote in message
news:7DA52299-3CA1-49B6-8AD7-(E-Mail Removed)...
> I've attempted to do some research on this but land up in the sections of
the
> book(s) that deal with programming (which I am not yet there) so I look
for
> your help at MS Discussion.
>
> There are two fields that I would like to include on this one specific
> report which call for the calculation of the Average and the Median
> (statistical functions).
>
> I have heard it said that all I have to do is call the Excel worksheet
> function from Access ... 'you must have a reference set to excel or late
bind
> to excel as these worksheet functions are called from excel ...
> 'worksheetfunction.Excelfunctionname AnyParametersneeded'.
>
> That's still unclear to me. I am such a newbie at creating modules etc.
> that I need more tutoring on this in order to make it happen.
>
> Can anyone help?
>
>
> --
> Thanks,
> Steve D

ouch! it seems i know less of the topic than i originally thought. thank you
none-the-less for offering some insight into this new area of learning for
me. i hope you have a pleasant day.

"Jeff Boyce" wrote:

> Steve
>
> The book tells you that use of references involves programming. You post in
> a "programming"-related newsgroup. But you want a non-programming
> explanation?! <g>
>
> To use the Excel function, after you've set a reference to it in Access,
> you'll need to 'ken' some programming. To set the reference, create a new
> module, click Tools|References, and locate the line that has your version of
> MS Excel. Check the box and Save/close. Your mdb now has a reference to
> the Excel object model, including the Median function.
>
> By the way, Access does have an "Average" function, as part of its Totals
> query -- but it does expect to have normalized data to work on.
>
> --
> Good luck
>
> Jeff Boyce
> <Access MVP>
>
> "Steve D" <(E-Mail Removed)> wrote in message
> news:7DA52299-3CA1-49B6-8AD7-(E-Mail Removed)...
> > I've attempted to do some research on this but land up in the sections of
> the
> > book(s) that deal with programming (which I am not yet there) so I look
> for
> > your help at MS Discussion.
> >
> > There are two fields that I would like to include on this one specific
> > report which call for the calculation of the Average and the Median
> > (statistical functions).
> >
> > I have heard it said that all I have to do is call the Excel worksheet
> > function from Access ... 'you must have a reference set to excel or late
> bind
> > to excel as these worksheet functions are called from excel ...
> > 'worksheetfunction.Excelfunctionname AnyParametersneeded'.
> >
> > That's still unclear to me. I am such a newbie at creating modules etc.
> > that I need more tutoring on this in order to make it happen.
> >
> > Can anyone help?
> >
> >
> > --
> > Thanks,
> > Steve D
>
>