Is it possible to generate a PRODUCT like in Excel?

Hi, I would like to create a product as a summary - but
there seems to be no product function. I toyed with the
idea of using logarithms, but sadly there is no "power"
function either. Is it possible to do this?

I have included the SQL below as what I would *like* to do.


SELECT DISTINCTROW
Calculations.ClientAccountNumber, "PRODUCT"
(Calculations.AdjFactor) AS TotalAdjFactor
FROM Calculations;


Many thanks, chris

You can try
Select ClientAccountNumber, Exp(Sum(Log([Qty3]))) as TotalAdjFactor
FROM Calculations
GROUP BY ClientAccountNumber;


--
Duane Hookom
MS Access MVP


"Chris" wrote in message
...
Hi, I would like to create a product as a summary - but
there seems to be no product function. I toyed with the
idea of using logarithms, but sadly there is no "power"
function either. Is it possible to do this?

I have included the SQL below as what I would *like* to do.


SELECT DISTINCTROW
Calculations.ClientAccountNumber, "PRODUCT"
(Calculations.AdjFactor) AS TotalAdjFactor
FROM Calculations;


Many thanks, chris

I bow down to your wonderfulness.

Many thanks.
-----Original Message-----
You can try
Select ClientAccountNumber, Exp(Sum(Log([Qty3]))) as
TotalAdjFactor
FROM Calculations
GROUP BY ClientAccountNumber;


--
Duane Hookom
MS Access MVP


"Chris" wrote in
message
...
Hi, I would like to create a product as a summary - but
there seems to be no product function. I toyed with the
idea of using logarithms, but sadly there is no "power"
function either. Is it possible to do this?

I have included the SQL below as what I would *like* to
do.


SELECT DISTINCTROW
Calculations.ClientAccountNumber, "PRODUCT"
(Calculations.AdjFactor) AS TotalAdjFactor
FROM Calculations;


Many thanks, chris


.