Over all Average

[Guest]

i am trying to get an over average on stats that is entered in the database.
When I create a qurey i use the average formula for each field that applys.
Once I run th ereport each entry that is entered appears. I am trying to have
it show just the average of all enteries. Is this possible.

 

[Wolfgang Kais]

Hello gwtechie72.

i am trying to get an over average on stats that is entered in the
database. When I create a qurey i use the average formula for each
field that applies. Once I run th ereport each entry that is entered
appears. I am trying to have it show just the average of all
enteries. Is this possible?

Well, you could base the report on your averaging query.
Or, you can use your previous report and add average formulas in the
report footer. To hide the details, make the detail section invisible.

 

[Guest]

How is this done. I have tryed to average out and when I run the report all
the enteries still show

 

[Wolfgang Kais]

Hello gwtechie72.

How is this done. I have tryed to average out and when I run the report
all the enteries still show

You base the query on the core data, the detail section will contain
controls that display those values. In design view of the report, you
can click on the details section marker and then use the properties
window to change the property "visible" to false.
If you wanted to see the average of a field named ValueX, you should
add a textbox to the report footer section that as a control source
of "=Avg([ValueX])" (without quotes).