Moving Average 1

[VC2002]

Hi!

I realise this is probably a simple question, but I cant get to grips with it!

I have a table containing two fields - price and data. I wish to run a query that will contain the two fields mentioned and a field that will calculate the average price for the previous 15 days, up-to and including the most recent date.

As more records are added, the query should update the moving average.

Is this possible and how?

Thanks a lot!

 

[DonQuichote]

make a query like:

SELECT Avg(price) FROM yourTableName WHERE DateDiff('d',data,now)<=15;

with the right table and field names.

Best regards

 

[VC2002]

Sorry, but with the following expression, what should go in the 'data' and 'now' parts?


WHERE DateDiff('d',data,now)<=15;

 

[DonQuichote]

data

is the field containing the date and

now

is a built-in function that returns the current date and time. The

'd'

says that you want the difference in days.

Best regards

 

[VC2002]

Thats brilliant, thanks a lot!