Geometric Mean in a report

G

Guest

Hi
I'm trying to setup the formula for calculating the Geometric Mean for a group of records using a formula such as
=geomean([field name]
All I get is a "enter parameter value" screen. It works in excel but not in access. Is there a different function I need to use

Thanks,
 
J

Jeff Boyce

I don't recall seeing a function in Access for Geometric Mean. Have you
tried setting a reference to Excel (open a code module, click on
Tools|References, check an MS Excel object model)? That way, you could use
the Excel function in an Access function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

geometric mean of a series of negative asset returns 8
I need to calculate a Geometric mean 7
Access 97 Report Problem...... 3
Re: Geometric mean 1
What is the formula for geometric mean with some negative data 1
Access 2003 functions 3
how to input a calculation in excel to find the geometric mean 3
How do I calculate a geometric mean in Access 2003? 4

Top