Hi Richard,
In response to your request re my query, this is how it looks in Excel (what I need to do in Access...)

The excel array formula is
{=product(1+(B1:B3)-1} and the result = 0.140275

where:

          Col A         Col B

Row 1)  4/30/2010 0.0035
Row 2)  5/31/2010 0.0236
Row 3)  6/30/2010 0.1101


Thank you!
Orlando

---

Reply from Richard Rost:

I've tried recreating your sheet using the array function, and I just get an error for that formula. Are you sure you copied it correctly? What are you trying to calculate?