Geometric Mean in a report

  • Thread starter Thread starter Guest
  • Start date Start date
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,
 
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.
 
Back
Top