[AccessD] Calculate Quartile

I wonder why Windows is not taking care of the comma/period problem if you
have the , as the decimal point in the regional setting? Can you modify the
source of ashish formula to get the numbers into the formula correctly?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of philippe pons
Sent: 04 July 2009 15:11
To: Access Developers discussion and problem solving
Subject: [AccessD] Calculate Quartile

Hi all,

I spend several days trying  to calculate quartile in access.
I don't want to use the quartile function from excel.

I currently try using a formula I found from dev ashish site.

Works well with English regional settings, but failed with my French
regional settings: we have the bad habit
of using a coma as decimal separator!, and this makes the function end up in
error.

I found there is a QUARTILE function from the MS Office Web Components
function Library (MSOWCFLib)

It's syntax is: Function QUARTILE(array As IXRangeEnum, quart As Double)

I don't know how to pass a parameter of the IXRangeEnum type to this
function.
google was not my friend in this situation!

Any idea to do that?

Any better idea?

TIA,

Philippe
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--------------------------------------------------------------------
myhosting.com - Premium Microsoft® Windows® and Linux web and application
hosting - http://link.myhosting.com/myhosting