Calculating off two calculated values

  • Thread starter franklinbukoski
  • Start date
F

franklinbukoski

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

Duane Hookom

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

franklinbukoski

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating averages 13
calculations in report controls 2
Percentages on time calculations 3
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
averaging a field value if field value is greater then 0 access report 4
Count Only Weekday in the DateDiff Function 1
Adding the Total Days Generated by the DateDiff Function 4
Calculations with possible null value fields 1

Top