Is it possible to generate a PRODUCT like in Excel?

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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


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
Click to expand...


.
Click to expand...
 
Back
Top