moving average calculations

[pd2004]

Hello,

I have a table with time series information. It has the following fields:

Category
Date
Sales

I want to use a query to add a field with a moving average (10 day) of the sales data for each date/category combination. I know this is probably simple, but I have never been able to figure out how to do it. Any assistance is greatly appreciated.

Thank you,

Pat

 

[lespaul]

maybe:

WHERE Date[Date] BETWEEN (Today()) and (Today() - 10)

not positive that Today is the right function, but there's a way to get today's date using a function, it may be Now() or Date().

HTH

Leslie