Calculating Monthly Averages in a Query

K

Katherine

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?

Thanks,
Katherine
 

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

Similar Threads

Change a report to a query 1
Apply Month End date based on transaction date 5
Crosstab Query results/ Sum 7
Calculating % Change 3
Sorting Month-Year in Query 7
Calculating a grand total for an unbound control in a report 9
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Query to lookup and multiply by exchange rates 1

Top