MS Access and using the Average function in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help pleaes.
i am trying to do a project where i need to make a report which is sweet but
where i am struggling is where they also want to find out an average on the
amount of days someone has stayed but only being new to the calculations
using MS Access i have no idea how they work in there only in Excel please
help me if you can
 
In any report or group (not page) header or footer, you can use a text box
with a control source like:
=Avg(DateDiff("d",[StartDate], [EndDate])
If you can't figure this out, then come back with enough information
regarding your report record source and maybe some sample data and desired
display.
 
Back
Top