After I made a report, I also wanted to show the average value calculated at the bottom of specific column. So in Design View,I added a text box on Detail section and typed Control source as =Avg([value column's name]), then it showed the average value of that column correctly, but it show repeatly under every single values of that column..like this
Column A
105
Average value 95
85
Average value 95
95
Average value 95
Actually I want only one average value show at the bottom of that column..like this,
Column A
105
85
95
Average value 95
Even I changed to add that average value box in other sections such as in Footer, it still have the same problem and sometime show as error.
how can I do... please???
Column A
105
Average value 95
85
Average value 95
95
Average value 95
Actually I want only one average value show at the bottom of that column..like this,
Column A
105
85
95
Average value 95
Even I changed to add that average value box in other sections such as in Footer, it still have the same problem and sometime show as error.
how can I do... please???
Thank you so much databasedonr for your help.
