How do I get average days to fill?

[Evelyn Williams]

I have a report that provides the date of a requisition that was submitted to
a manager and the date of hire, if that candidate was choosen. I'm trying to
get average days to fill....What is the expression/equation to get average
days to fill a position? I keep getting zeros.

 

[KARL DEWEY]

Try this --
Sum(IIF([HireDate] Is Null, 0, [HireDate]-[RequisitionDate]+1)) /
Sum(IIF([HireDate] Is Null, 0, 1))

 

[John Spencer]

I would try the following. Either as the source of a control in the report
footer of a database or as an expression in a totals query if you are using
one for the source of your report.

Avg(IIF([HireDate] is Null,Null,DateDiff("d",[RequisitionDate],[HireDate])))

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County