[AccessD] Calculate Quartile

You could, for example, put the value into a string, then use the replace()
function to change the comma to a decimal point and then put the value back
out again and then input it into your quartile function.

Might work

Max


-----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