Average formula on access

[chivo123]

Hey all,
I was wondering if I could be able to use the average formula on calls in forms.
I have begin date, end date, agent name, and I would want to take the difference between those dates and returns the average of calls. I was successfully able to return the difference dates, but I can't get the average calls to work. Here is what I use for the average formula:



=IIf([End Date]>[Date],DateDiff("d",[Date],[End Date])=Sum([Average wrap]),0). I put this formula inside TEXTBOX inside the form.

[aytee111]

Are you showing all agents records on the form or one at a time? If all then this would be a total shown on the footer. If one at a time then you would do this in the record source.

[chivo123]

Thanks for the reply back, I'm doing this individually. Also, I have put this formula (=IIf([End Date]>[Date],DateDiff("d",[Date],[End Date])=Sum([Average wrap]),0) inside the control source, but it doesn't return me any values. It does return me the difference dates formula though which is this. =DateDiff("d",[Date],[End Date]).