Calculations in a report

[Mobiusrune]

I have a report that comes from a query with multiple expressions. The expressions look something like this:

IIF([TimeArrive]>[TimeTriage],DateDiff("n",[TimeArrive],[TimeTriage])+1440,DateDiff([TimeArrive],[TimeTriage]))

This works great and my report gives me my columns for each expression in minutes they way it should. Now here is the question...is there a way to insert a text box for each column/expression so I can calculate the Average for each column/expression?

i.e. I want the report to show the average minutes of Expr1 and Expr2, etc at the bottom of each column.

 

[Mihail]

Create unbound text boxes on the report footer and set the control source for each one to

=Avg([FieldName])

Is this what you are looking for ?

 

[Mobiusrune]

That was what I was looking for. My problem was that I was using the Excel formula AVERAGE() instead of Avg([]). Much appreciation for the help.