469,362 Members | 2,450 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,362 developers. It's quick & easy.

Viewing Total in Report

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
2 1105
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
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.

Similar topics

1 post views Thread by Rajani | last post: by
4 posts views Thread by Bill Dika | last post: by
2 posts views Thread by Michael Keene | last post: by
10 posts views Thread by NH | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.