I was thinking that was what would be necassary.
I have a table of monthly return data for an investment. What the function will do is multiply together a compound return for the period in question. If i knew the VBA for the sum function, it would be a simple matter of switching the +'s to *'s.
Below would be a specific example:
Oct 05 1.1%
Nov 05 1.3%
Dec 05 2.5%
If I specified a three month time period through a form (i can do this part), I might get data like above. What I would wantr to see is the compound return, which would be 1.011(1+the return value)times 1.013 times 1.025, or 1.0497 as a totak number. This data item indicates a that there is a 4.97% return over that time period. Again, so easy in Excel, so hard in Access. Thanks for helping out.