Finding the average

[laurat]

I have never done math on a report so I need some help at this. I have two date fields and I have another column that calculates the number of days between these two dates called DaysElapsed. Now I would like to calculate the average of this column and store it in the footer section. First of all how would I accomplish this? And secondly, if the report is two pages, would it calculate the whole report and show it on the last page or would it calculate each page separately and put the average for the first page on that page and the average for the second page on that page. That may be a stupid question but I am not sure how it works. I would like it to calcuate the whole report and show the total at the end. Thanks in advance for any help!!

 

[3699wat]

Go to MSAccess help and look for the following topic

Calculate a total or average for a group of or all records in a report

It will show you exactly how to do it. If you need more help later please repost

Marcel

 

[laurat]

Thank you, I tried the help before but couldn't find the right thing. How can I format it so that there are only two digits after the decimal place. There are ten digits right now. I went into the properties and changed it in there but it didn't work. Any suggestions??

 

[3699wat]

Did you set the Format property to Fixed when you set the Decimal property to 2????

 

[laurat]

I just set it to fixed and it worked. Thanks again!!