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

SQL for running average calculations

P: n/a
MLH
I've seen suggestions showing how to display running averages
on reports in this NG, but not too much on displaying them with
a query. I'm wondering if it's just not possible, or if it's just not
popular.

Suppose you have a table, tblPmtsRcd with amounts & dates
spanning a 24-month period. Now suppose you'd like a query
to display 24 records (for the 24 months) with 2-columns: the
first showing the sum of payments received each month and
the second showing the running average of all monthly cash
receipts from the beginning up through the current month for
each row.

SQL that would accomplish this would be an elegant way to
feed data to a graph. But I didn't see any examples to follow.

Mar 9 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
MLH <CR**@NorthState.netwrote in
news:vv********************************@4ax.com:
I don't care to change 8-years of higher
education because some crippled brained intellectual on the Access
Development Team doesn't know what a Cartesion plane is.
It's hard to change the colour of those reeds after the basket is wove.
Mar 10 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.