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?

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