[AccessD] Total in Footer of Report

You should be able to accomplish this by using the "Running Sum"
property of the text box, setting it to "Over Group".  The available
options on this property are "No", "Over Group", and "Over All".

-----Original Message-----
From: Paul Liadis [mailto:pnl1 at psu.edu] 
Sent: Tuesday, March 18, 2003 11:19 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Total in Footer of Report


Hi all,
I have an Access report in which I want to display a total in a 
footer.  The total is fine on the first page, for the first location.
Once 
the report hits the second location, however, the total does not get 
initialized and adds to the previous location's total.  I would like to 
initialize the textbox that displays the total after every 
location.  However, Access won't let me change the textbox's text
property 
to be equal to zero.  I am using the following code:

me.txtFoo.setfocus
me.txtFoo.text = 0.

Please give me some advice on how to accomplish what I am trying to 
accomplish.  Am I EVER able to set the text property of a textbox in a
Report?

Thanks in advance,

===============================================
Paul Liadis
Senior Applications Programmer/Analyst
University Budget Office
Pennsylvania State University

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com