calculated field (1 Viewer)

S

scs

Guest
i have a report that calculates the number of days between two dates -- how do i have the report calculate the average number of days for the records on the report?
 

Travis

Registered User.
Local time
Yesterday, 22:39
Joined
Dec 17, 1999
Messages
1,332
add a field to you report footer and make its Control Source to:

=Avg("Calculation for the Date Difference (e.g., datediff("d",[Date],Now))")
 

Users who are viewing this thread

Top Bottom