Running Average in MS ACCESS Query.

[John Grewar]

Hello,

I have actually asked this before but can't find it on the site (I'm still new here). I have got numerical data coming into my database twice a day for each specific subject that is being measured. When my project gets going it will continue for > 6 months so it will be a lot of data in the end. I need to create a running average of the numerical data for each subject for the last 7 days. This needs to be a continous evaluation and not just once off. I need the running average for that subject every day. Can anybody help me with this. I have tried using "Todays Date" - 7 days in a query but that doesn't account for days not measured (eg weekends) What I need is the last 7 "Measured" days.

Thanks for your help in advance,

John

[Rabbit]

In the criteria

>= iif(Day(Date()) = 2, Date - 11, Date - 9)

[MMcCarthy]

Hello,

I have actually asked this before but can't find it on the site (I'm still new here).

John

To find your previous posts either go to control panel at top RHS of page and look in List Subscriptions or click on your name to take your into your profile where you will be able to access a list of all questions and all posts.

Mary

[NeoPa]

Hello,

I have actually asked this before but can't find it on the site (I'm still new here). I have got numerical data coming into my database twice a day for each specific subject that is being measured. When my project gets going it will continue for > 6 months so it will be a lot of data in the end. I need to create a running average of the numerical data for each subject for the last 7 days. This needs to be a continous evaluation and not just once off. I need the running average for that subject every day. Can anybody help me with this. I have tried using "Todays Date" - 7 days in a query but that doesn't account for days not measured (eg weekends) What I need is the last 7 "Measured" days.

Thanks for your help in advance,

John

John,

Your previous thread on the subject (Running Average).
I suspect that if you provide us with details of how your data is stored (Table MetaData) then someone could give you some help returning this information in a query. An example layout for the MetaData follows :


Table Name=tblStudent

Field; Type; IndexInfo
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time