Calculating off two calculated values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a textbox I calculate days it takes to process an action with the
following:
IIf( Is Null, DateDiff("d", [a], Date()),
DateDiff("d", [a], )))

I now would like to calculate average time it takes to process an action.

I have another textbox that counts total records:
=Count(*)

How do I total the days from the first formula and divide that total by the
second formula?
 
Try
=Sum(DateDiff("d", [a], Nz(,Date())))/Count(*)
Or
=Avg(DateDiff("d", [a], Nz(,Date())))
 
Like a charm! THANK YOU!

Duane Hookom said:
Try
=Sum(DateDiff("d", [a], Nz(,Date())))/Count(*)
Or
=Avg(DateDiff("d", [a], Nz(,Date())))

--
Duane Hookom
Microsoft Access MVP


franklinbukoski said:
I have a textbox I calculate days it takes to process an action with the
following:
IIf( Is Null, DateDiff("d", [a], Date()),
DateDiff("d", [a], )))

I now would like to calculate average time it takes to process an action.

I have another textbox that counts total records:
=Count(*)

How do I total the days from the first formula and divide that total by the
second formula?
Click to expand...
Click to expand...
 
Back
Top