Geometric Average in Access 07

[QAHeld]

Does anyone know how to create a Aggregate function for the geometric average?

Thanks,

[Oorang]

Me:) First you can pop it into Excel and use GEOMEAN. But if you want to do it in Access I have questions:
What is the data type (currency, double, long, etc)?
How many records are we talking?
Is it a linked table or an Access Table?
Were do you intend to use the function (form, report, query, etc?)

[OBP]

Aaron, does that mean that the Op can call that Excel GEOMEAN Function from Access, see this -
http://oreilly.com/pub/h/3310

[Oorang]

No, not really:) I meant export it to Excel and use GEOMEAN. I was thinking about giving him/her a wrapper, but I thought I would wait until I understood the context to make sure that was going to be the best solution.

[tilamok]

[quote=OBP]Aaron, does that mean that the Op can call that Excel GEOMEAN Function from Access, see this -


This code is pure genius :clap: :clap: :clap: :clap: :clap:
Thanks

[CLJ1959]

Aaron, does that mean that the Op can call that Excel GEOMEAN Function from Access, see this -
Hi I understand the idea expressed in the link above but I need help getting that code to do the GEOMEAN in access. Would some kind person write the code and show me how to use it?

I presume there must be some kind of limit on the number of records over which a geometric mean can be used as the product total can get astronomically big very quickly. Is this the case?

Regards Chris