product function

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
 
R

Rick B

Jerry: Stick to one post please. Follow your previous post for responses.

Folks: This is a duplicate post.
 
K

Klatuu

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?
 
R

Rick B

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

jerry

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
 
M

Marshall Barton

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


Go back and check John Vinson's expression in your other
thread.
 
Top