Viewing Total in Report

[Michael Keene]

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.

[MGFoster]

Re: Viewing Total in Report

Michael Keene wrote:
[color=blue]
> 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.[/color]

-----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 "StudentCou nt."

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(StudentCou nt)

This should produce the total student count for the report.

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

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

iQA/AwUBQIRBnYechKq OuFEgEQJu+wCgrc dGXLZ8UqAElOnoi FYrcMIkqeAAn1oz
MMTlrpCFw2OI17Q HwjrIDnpI
=gH7W
-----END PGP SIGNATURE-----

[Michael Keene]

Re: Viewing Total in Report

Thanks that did it.


MGFoster <me@privacy.com > wrote in message news:<ukXgc.269 0$e4.1549@newsr ead2.news.pas.e arthlink.net>.. .[color=blue]
> Michael Keene wrote:
>[color=green]
> > 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.[/color]
>
> -----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 "StudentCou nt."
>
> 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(StudentCou nt)
>
> This should produce the total student count for the report.
>
> --
> MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQIRBnYechKq OuFEgEQJu+wCgrc dGXLZ8UqAElOnoi FYrcMIkqeAAn1oz
> MMTlrpCFw2OI17Q HwjrIDnpI
> =gH7W
> -----END PGP SIGNATURE-----[/color]