S
Scott
I have a query setup with many fields, including times - to keep this short 2 of the fields are [CallReceivedTime] and [DispatchTime]
In my query, i added an expression like this Format([CallReceivedTime]-1-[DispatchTime], "Short Time') to give me the number of minutes between the two times in a field called [DiffRecDisp]
Now I need to find out how to get an average based on that expression. Do I do this in the report or in the query? I tried in the query but I kept getting a data mismatch error when i entered AvgDiffRecDisp:[DiffRecDisp] with AVG in the Total line - all the other fields have group by in the Total line.
Any information on getting this accomplished would be greatly appreciated... Thanks for a helping a newbie out.
In my query, i added an expression like this Format([CallReceivedTime]-1-[DispatchTime], "Short Time') to give me the number of minutes between the two times in a field called [DiffRecDisp]
Now I need to find out how to get an average based on that expression. Do I do this in the report or in the query? I tried in the query but I kept getting a data mismatch error when i entered AvgDiffRecDisp:[DiffRecDisp] with AVG in the Total line - all the other fields have group by in the Total line.
Any information on getting this accomplished would be greatly appreciated... Thanks for a helping a newbie out.