How do I get average days to fill?

  • Thread starter Thread starter Evelyn Williams
  • Start date Start date
E

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.
 
Try this --
Sum(IIF([HireDate] Is Null, 0, [HireDate]-[RequisitionDate]+1)) /
Sum(IIF([HireDate] Is Null, 0, 1))
 
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
 
Back
Top