Summing a Group Footer Field

  • Thread starter Thread starter Brennan
  • Start date Start date
B

Brennan

Hello:

I have a field that is in a group footer called txtYear3.

I would like to sum all of the values for this group at
the end of the report. I have used the folloing syntax in
a text box in the Report footer

=Sum(txtYear3)

When I run the report, I get an error message saying that
the Microsoft Jet Database does not recognize the field
txtYear3.

What am I doing wrong?

Any comments or suggestions would be appreciated.

Brennan
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sum the column (field) in the report's RecordSource. IOW, use the
column name that is the ControlSource of the control txtYear3 in the
report footer's sum control. E.g.:

txtYear3 ControlSource: Year3 (one of the columns in the report's
RecordSource)

footer TextBox ControlSource: =Sum(Year3)


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBKvfIechKqOuFEgEQKxHwCgnpOgA/18WBvlo7taIon9SNkaGIAAoP9w
jqLj0kY2j/j4kSLHf7bMbMsD
=yLc3
-----END PGP SIGNATURE-----
 
Back
Top