Formulas in Access Reports and forms

[Guest]

Hi,

I have about 30 records and when I create a form I set it up as a columnar
layout so hopefully all my records will be on one page. I have a number of
max, min, and average functions that return results from all records. I have
them displaying as text fields. What I would like to do is one part of my
report has all the records listed in a columnar layout and then have a
separate section that has text fields that have min, max, and averaging
functions that return the results for each column or field. But the report
would also be on one page. If I try to put these fields with the functions in
the detail section of the report then the text fields or functions are
displayed for each record. If I put them in the footer then I get an error.
Any ideas would be great.

Thank You,

 

[Arvin Meyer]

The aggregate functions should work in both the report footer or possibly a
group footer. A text box in the report footer would have a control source
like:

=Sum([MyFieldName])

or:

=Avg([MyFieldName])

Min and Max generally have a single value, or a single value for a group of
records, and thus they aren't really conducive to that kind of aggregation.
Try using them in a query, then build a subreport based on that query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access