By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Viewing Total in Report

P: n/a
I'm pretty much a beginner with Access but do have some experience but
I'm stuck on this problem. Any suggestions would be appreciated. I
have a very simple database that tracks the number of students
enrolled in our school. I have designed a report that lists the
families and the number of students per family. I would like to have
the total number of students enrolled show up on the report. I can run
a query that will total the number for me, but how can I get this to
show up on my report?
Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Michael Keene wrote:
I'm pretty much a beginner with Access but do have some experience but
I'm stuck on this problem. Any suggestions would be appreciated. I
have a very simple database that tracks the number of students
enrolled in our school. I have designed a report that lists the
families and the number of students per family. I would like to have
the total number of students enrolled show up on the report. I can run
a query that will total the number for me, but how can I get this to
show up on my report?
Thanks.


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

Depends on the name of the column in the report's RecordSource that
holds the number of students per family. Let's name it "StudentCount."

In the report's footer place a TextBox wherever you want the student
total to appear. Put something like this in it's ControlSource property
(under the Properties dialog box Data tab):

=Sum(StudentCount)

This should produce the total student count for the report.

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

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

iQA/AwUBQIRBnYechKqOuFEgEQJu+wCgrcdGXLZ8UqAElOnoiFYrcM IkqeAAn1oz
MMTlrpCFw2OI17QHwjrIDnpI
=gH7W
-----END PGP SIGNATURE-----

Nov 12 '05 #2

P: n/a
Thanks that did it.
MGFoster <me@privacy.com> wrote in message news:<uk****************@newsread2.news.pas.earthl ink.net>...
Michael Keene wrote:
I'm pretty much a beginner with Access but do have some experience but
I'm stuck on this problem. Any suggestions would be appreciated. I
have a very simple database that tracks the number of students
enrolled in our school. I have designed a report that lists the
families and the number of students per family. I would like to have
the total number of students enrolled show up on the report. I can run
a query that will total the number for me, but how can I get this to
show up on my report?
Thanks.


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

Depends on the name of the column in the report's RecordSource that
holds the number of students per family. Let's name it "StudentCount."

In the report's footer place a TextBox wherever you want the student
total to appear. Put something like this in it's ControlSource property
(under the Properties dialog box Data tab):

=Sum(StudentCount)

This should produce the total student count for the report.

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

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

iQA/AwUBQIRBnYechKqOuFEgEQJu+wCgrcdGXLZ8UqAElOnoiFYrcM IkqeAAn1oz
MMTlrpCFw2OI17QHwjrIDnpI
=gH7W
-----END PGP SIGNATURE-----

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.