By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Product of Row Entries

P: 2
I need to find a way to get a product of a particular field across many rows.
Keeping it simple, my example table is as follows:

Month Montly Return (%)
Jan 20
Feb 10
Mar 25

Thus, my return for the quarter would be ((1.2)(1.1)(1.25))-1)=0.65=65%

In reality, the above is generated from another query in such a way that every month has a row entry, and every return is non-null, and everything is sorted by date.

The calculated value can go into another table, or another query, or can be stored as a variable in VB for all I care -- I just need the figure in some way shape or form.

Oct 11 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.