product function

  • Thread starter Thread starter jerry
  • Start date Start date
J

jerry

Hi,
what I need is the product of one field of more than one row
(Something like =sum(field))
But I don`t need sum,I need product.
Can anyone help,please
 
Jerry: Stick to one post please. Follow your previous post for responses.

Folks: This is a duplicate post.
 
More detail, please. There is no product function in Access or VBA. Product
usually refers to a multiplication. What are you really trying to achieve?
 
Read his previous post - there are details there.
Klatuu said:
More detail, please. There is no product function in Access or VBA. Product
usually refers to a multiplication. What are you really trying to achieve?
 
I have one table looks like this

IdNr amount Name
001 5.2 gg
002 3.1 gg
003 1.7 kk

Just an example
What I need now is a function that calculates
5.2*3.1*1.7
 
Back
Top