Multiply values in the same field

[herbertioz]

Hi,

I have tried a long time to fix this issue, but I am stuck.
Could someone help me out here ,please?:banghead:

I have a field called "Test"

Id Test
1 2
2 4
3 6

Output from my query:
48

How can I get 48 as the result from the query? Its like a running multiply.

 

[MarkK]

You can't do this efficiently in a query. Instead you need to open a recordset, loop thru each row, and do the calculation with each value.

 

[herbertioz]

Ok, I see. Then back to work Thanks!

You can't do this efficiently in a query. Instead you need to open a recordset, loop thru each row, and do the calculation with each value.