Calculating off two calculated values

[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?

 

[Guest]

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

 

[Guest]

Like a charm! THANK YOU!

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

--
Duane Hookom
Microsoft Access MVP

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?