MS Access and using the Average function in a report

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
getting an average on the "Count" in a report summary 2
Printing report for Invoice 0
calculations in report controls 4
Access Report calculations? 5
Expression in a report 10
averaging a field value if field value is greater then 0 access report 4
Average function 9

Top