Need help to know How to Multiply results in a report

  • Thread starter Thread starter Omorasoules
  • Start date Start date
O

Omorasoules

Hi everybody, I hope you can help me out with this issue. I have an access
report in which I need to multiply each value in the results, just imagine a
running sum, but instead of summing the values it would be a multiplication.
See example:

Group 1 - 1500
Record1 - 10
Record2 - 15
Record3 - 5
Record "N" - 2
Total 1500 ( This multiplication is what I need to get. The total is
obtained from 10 x 15 x 5 x 2)

Group 2 - 216
Record1 - 3
Record2 - 6
Record3 - 1
Record4 - 6
Record "N" - 2
Total 216 ( This multiplication is what I need to get. The total is
obtained from 3 x 6 x 1 x 6 x 2)

¿Does anyone have an idea of how to do this?
Thanks a lot
Oscar
 
Oscar

In a database, it all starts with the data.

If you'll describe a bit more specifically what the numbers represent, and
perhaps what you will do with a "running product", the newsgroup readers may
be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You can try an expression in a report or group header or footer like:
=Exp(Sum(Log([Num])))
 
Back
Top