Average Days

[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

 

[Eric Butts]

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

 

[Eric Butts]

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()