Hi Richard,
I am taking your courses and this will probably be covered in future but here goes:  
I need for the result of a query (could be in a report) to perform an array calculation such as in MS Excel's formual....=Product(1+(a1:a3)-1 where a1 = the beginning period value and a3 is the ending period value.  Will this be possible in access?  Basically it is geometrically linking returns and performing investment performance calculations.  Thanks.  Love your course...Recommend to all!

---

Reply from Richard Rost:

I'm not exactly sure I understand what you're trying to do, but if you're trying to mimic the PRODUCT function in Excel (which multiplies all of the numbers in a range) then you would have to use something like a Recordset to loop through all of the records in your range and manually multiply their values. If you can give me an example of exactly what you're trying to do, I'll try to help you more.