Calculating Monthly Averages in a Query



Say you calculate total sales every month by pulling out "month" from each
sale date using the DatePart function, and setting "Month" to "Group By" and
"Sales" to "Sum".

How would you use the SumOfSales column to calculate the average sales per
month? I want the number of months to be a parameter so it can be changed
depending on how many months' data has been entered.

Is there an easier way to do this than using the Sum setting in a query?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question