If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report problems (sums, avgs, etc)
I have created a report that pulls up the information
between the begin date and end date according to the unit number (unique vehicle number). Now my boss wants some of the fields in the report to show the sums of those fields as well as avg of other fields at the end of the report (after the last line prints). Also he has requested for cetain fields a min and max value field to also be displayed. I have tried everything I can think of and am now at a total loss as to what to do. Any assistance would be greatly appreciated. |
#2
|
|||
|
|||
Report problems (sums, avgs, etc)
This stuff is fairly basic. The first step is to make sure that you place
your summary text boxes in the Report Footer section and not the Page Footer section. Then it's setting your control source to something like: =Sum([Your Numeric Field]) =Avg([Your Numeric Field]) =Max([Your Numeric Field]) -- Duane Hookom MS Access MVP "ChuckA" wrote in message ... I have created a report that pulls up the information between the begin date and end date according to the unit number (unique vehicle number). Now my boss wants some of the fields in the report to show the sums of those fields as well as avg of other fields at the end of the report (after the last line prints). Also he has requested for cetain fields a min and max value field to also be displayed. I have tried everything I can think of and am now at a total loss as to what to do. Any assistance would be greatly appreciated. |
#3
|
|||
|
|||
Report problems (sums, avgs, etc)
Thanks for the help Duane. Never use that section down there so didnt think to try what I was doing there. Otherwise I had it correct just in wrong place on report. Thanks again.
|
Thread Tools | |
Display Modes | |
|
|