(Msg. 1) Posted: Mon Oct 06, 2008 2:42 pm
Post subject: Calculating Monthly Averages in a Query Archived from groups: microsoft>public>access (more info?)
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?
(Msg. 2) Posted: Mon Oct 06, 2008 3:16 pm
Post subject: RE: Calculating Monthly Averages in a Query [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum