J
j.boswell
I have a table [USGS RAW NO TITLE] set up in access with water flow
sites. I am trying to calculate 7-day moving averages of flow for
each day limited by the site (3-days ahead and 3-days behind). I
think I have the expression working right on a 7-day moving average:
Expr1: DAvg("[USGS RAW NO TITLE]![Flow]","USGS RAW NO TITLE","[USGS
RAW NO TITLE]![datetime] BETWEEN " & Format(DateAdd("d",-3,[USGS RAW
NO TITLE]![datetime]),"\#m/d/yyyy\#") & " AND " & Format(DateAdd("d",
+3,[USGS RAW NO TITLE]![datetime]),"\#m/d/yyyy\#"))
However, I cannot get it to limit the averages to the site specific
data. Right now I think it is calculating across the sites, so if
two sites have a flow on the same day, it is using data from both
sites. I can't figure out how to limit it. I would do it in excel
but I have something around 1.5 million rows. Anything would help.
Jimmy
sites. I am trying to calculate 7-day moving averages of flow for
each day limited by the site (3-days ahead and 3-days behind). I
think I have the expression working right on a 7-day moving average:
Expr1: DAvg("[USGS RAW NO TITLE]![Flow]","USGS RAW NO TITLE","[USGS
RAW NO TITLE]![datetime] BETWEEN " & Format(DateAdd("d",-3,[USGS RAW
NO TITLE]![datetime]),"\#m/d/yyyy\#") & " AND " & Format(DateAdd("d",
+3,[USGS RAW NO TITLE]![datetime]),"\#m/d/yyyy\#"))
However, I cannot get it to limit the averages to the site specific
data. Right now I think it is calculating across the sites, so if
two sites have a flow on the same day, it is using data from both
sites. I can't figure out how to limit it. I would do it in excel
but I have something around 1.5 million rows. Anything would help.
Jimmy