I concider myself an average user and am having issues here with this problem. What I am trying to do is to create a report that has an average at the bottom. In the details I am using a formula (say it is [Total Time]) to find the difference in the start time and end time. Then in the report footer I am putting the formula "=AVG([Total Time])". When I put this formula in the report footer I get nothing. If I put it in the page footer, I get an error.
Does anyone have any tips for me to get this to work? Any help would be appreciated. Thanks everyone.
Does anyone have any tips for me to get this to work? Any help would be appreciated. Thanks everyone.