Use Report to Analyze, rather than list, Data??

[efelthauser]

Hello,

I am trying to use the Report function to analyze data. But I
primarily see in all the examples just LISTS of data from the database,
grouped on whatever.

I want to just do summary statistics on the data pulled from a query,
but, for example, when i try to get average age, I either get #Error,
or if i pull directly from the table, I get the average, but It is
repeated for like 70 pages.

Anyone know what's the deal and if access reports are meant to be used
like this?

Thanks!

 

[Marshall Barton]

I am trying to use the Report function to analyze data. But I
primarily see in all the examples just LISTS of data from the database,
grouped on whatever.

I want to just do summary statistics on the data pulled from a query,
but, for example, when i try to get average age, I either get #Error,
or if i pull directly from the table, I get the average, but It is
repeated for like 70 pages.

Depends on the report's record source query and the
expression you're using. Please post a Copy/Paste of the
query's SQL view and the average text box's control source.

Generally, this kind of report should calculate everything
in the query and the report should be trivial, but since you
didn't describe what you're trying to calculate, I can't be
sure that the general rule applies in this case.