Can you calculate average weekly sales in Access

J

Jo2

On a weekly basis, I need to calculate average weekly sales over the past 13
weeks. Is it possible to do this type of calculation in Access 2003? If so,
how?

Thanks!
 
B

Brian Camire

Yes, but how you do it depends what your data looks like. If it looks like
this:

Sales Date, Sales Amount
7/1/2005, $1.23
7/3/2005, $45.67
7/3/2005, $89.10
7/8/2005, $11.12

Then you might try a query whose SQL looks something like this:

SELECT
Sum([Sales Amount])/13 As [Average Weekly Sales]
FROM
[Your Table]
WHERE
[Sales Date] >= DateAdd("ww", -13, Date())
 
Top