Average Days

  • Thread starter Thread starter Owen
  • Start date Start date
O

Owen

Hello,

I have two reports; One has two fields called Date_Issued
and Date-Answered. Thanks to Marsh, I can determine the
average # of days between the two.

For the second report, I need to determine the average
number of days between Date_Issued and whenever the report
is viewed.

I have tried:
=Avg(DateDiff("d",[Date_Issued],[Now()])) and
=Avg(DateDiff("d",[Date_Issued],[Text9])), {Text9 being a
box on the report that indicates today's date}

and several other variations on that theme but all I get
in the report is #Error.

Please help

TIA
Owen
 
Hi,

Isn't [Date_Issued] on the first Report and not the 2nd Report?

Try:

=Avg(DateDiff("d",Reports![1st Report]![Date_Issued],[Now()]))


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
 
Try removing the squares around Now()

With the squares it's looking for a textbox control named Now() instead of
using the result of the function Now()

Note: you also can use the function Date()
 
Back
Top