I need to be able to perform a running average on a column ("IncomingPercent"---numbe
r field) based on "WeekEnding", which is a date field. I have attached the query data output and the query (as a pic and the actual SQL statement). Really could use expert help with this. Thanks.
eekEnding AS WeekEnding, Avg(dbo_InspectionEfficien
gPercent) AS Incoming, DAvg("IncomingPercent","db
" & [WeekEnding] & "#") AS Expr1
,1) And (dbo_InspectionEfficiency.
GROUP BY dbo_InspectionEfficiency.W
ORDER BY dbo_InspectionEfficiency.W