Re: MULT() instead of SUM()

Thanks for all

Finally, I will use the function :

Exp(sum(ln(Value)))

Best regards...
Chris...

gaussent wrote:

> Hi,
>
> I'm Chris from France.
> I would like to simulate an aggregate function which multiply instead
> off add.
> I would like to use it in query
>
> A function like SUM() which could be called MULT()
>
> SELECT NAME, MULT(QTY)
> FROM TABLE
> GROUP BY NAME
>
> Give me the result QTY * QTY * .... * QTY for each name.
>
> Is it possible and how can I do this.
>
> Thank you for your help.
>
> Christophe...
Received on Fri Nov 17 2000 - 03:12:18 CST