Viewing Total in Report - Microsoft Access / VBA

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.

Nov 12 '05 #1

Subscribe Post Reply

1242

MGFoster

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

Michael Keene

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

Similar topics

group total in a report

by: Rajani | last post by:

Hello, I have a table(msaccess) with the structure... job_code text 6 style text 10 qty number fabrication text 65 ship_date date/time

ASP / Active Server Pages

Report: Running Total Problem

by: Bill Dika | last post by:

Hi I am trying to calculate a running total of a calculated textbox (tbAtStandard) in GroupFooter1 for placement in a textbox (tbTotalAtStandard) on my report in Groupfooter0. The problem...

Microsoft Access / VBA

Viewing Total in Report

by: Michael Keene | last post by:

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

Microsoft Access / VBA

Show Total In Subreport On Main Report

by: Marie | last post by:

How do you display a total from a subreport on the main report. If it makes a difference, the total is a total of a calculated field (Qty * Price). Does the total on the subreport go in the...

Microsoft Access / VBA

gridview: "Viewing record x of y"

by: NH | last post by:

I have a girdview with paging enabled. How can I add a message in the footer to say "Viewing records 1-15 of 45" etc Thanks

ASP.NET

Group Total in Report - What am I doing wrong.

by: Sunil Korah | last post by:

Hi, I haven't used access reports much. I have a problem in getting the total of a group. I have 3 fields, ProgName (Program name), Pname (Participant's name) and PCategory (Participant...

Microsoft Access / VBA

Calculation in report to subtract one 'group' total from Grand Total

by: klarae99 | last post by:

I am working on an Inventory Database in Access 2003. I am working on a report that I could print when its time to file our State Sales Tax paperwork. The figures I need for this report are Total...

Microsoft Access / VBA

How to change rdlc between viewing/printing form

by: Deceneu | last post by:

Hi everyone, this is my first post so please bear with me. I have the following situation: i have a local report that needs to have two "versions": one for viewing in the report viewer (with all...

.NET Framework

sending a .rdlc report to printer directly without viewing it.

by: silverrock7 | last post by:

Hello Friends i m stuck up to a place wherein i want to print a report which is displaying on a reportviewer. I actually want to send the report to printer directly without viewing it. i am...

.NET Framework

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing