Although similar to the previous thread on totals, I am trying to get a more in-depth average
SQL Query I have embedded the report:
SELECT [Change Request].CR_No, [Change Request].[Change Requested], DateDiff("d",[Date_ID'd],[Date_Closed]) AS [Date ID_Closed]
FROM [Change Request]
WHERE ((([Change Request].[Change Requested])<>"Do not delete") AND (([Change Request].Action_Complete)=True) AND (([Change Request].Sub_No)=0));
This is what I have made for the overall average (in Header/Footer) =Format(Sum([Date ID_Closed])/Count([CR_No]),"Standard")
I am trying to get a rolling average in the details area for each row. CR........Change Requested......Date ID_Closed......Average
I believe I have it. Still some more research to do: =Format([Date ID_Closed]/[CR_No],"Standard")
If an easier way is found then LMK.
Thanks
I think I need to sum the output of the dates per row/CR_No to do this.
Thanks