Calculating the product of row data on a single field 
Author Message
 Calculating the product of row data on a single field

Similar to the computing the sum of data across row data on a particular
field, is it possible to calculate the product of row data on a single
field?  What I'd like to do is construct a financial calculation in which I
have return data on an account by month

ie
Sept    2%
Oct      4%
Nov     2%

To find out the total return for the period, the calculation would be:

[(1+Sept return) * (1+ October return) * (1+ Nov return)]

Any thoughts...

Thanks
tp



Thu, 08 Mar 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Calculating a field from same row for each row/record in form

2. assigning values of fields in a single row to variables

3. very important!; calculating totals row by row

4. Single-row refresh operation returned multiple row

5. Losing Calculated Form Field Data after File Save

6. Data Report (Calculated field problem)

7. data control, forms, calculated fields?

8. Product A = Product B + Product C + .......

9. enetring data from a same set of fields to different rows in a table

10. entering data from set of same fields to different rows in a table

11. single field to multiple field update qry

12. Single field into multiple fields

 

 
Powered by phpBB® Forum Software