Is it possible to generate a PRODUCT like in Excel?

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
 
D

Duane Hookom

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

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Image display in a query, is it possible? 1
How to generate product key? 6
Product Calculation in an Access Query 4
Query a table's particular column and return the field name. 3
Is It Possible To Generate An Auto-Incrementing Field? 3
auto-generate excel files 6
Calculate Days between dates of a sale for a particular product 2
is this query possible? 3

Top